Formula to get text from multiple cells in Excel 2007

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to get text from multiple cells in Excel 2007

FAQ

Thread Tools

Display Modes

11-13-2018, 05:24 AM

Marcia

Windows 7 32bit Formula to get text from multiple cells in Excel 2007

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Here you go:

=IF(ISNA(INDEX($B$1:$B$4,SMALL(IF($A$1:$A$4=TODAY( ),ROW($B$1:$B$4)-ROW($B$1)+1),ROWS($B$1:$B1)))),"",INDEX($B$1:$B$4, SMALL(IF($A$1:$A$4=TODAY(),ROW($B$1:$B$4)-ROW($B$1)+1),ROWS($B$1:$B1))))
Where Col B contains the list of cars
Col A the date/s

This is an array formula so confirm this with Ctrl+Shift+Enter

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Formula to extracting text from text string	Haha88	Excel	9	02-05-2018 01:04 AM
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
If text in column then formula in other	Grubermen	Excel	1	09-06-2017 06:35 AM
Editing the text a formula gets me	Jiing Chiang	Excel	7	02-08-2016 10:01 PM
extract text with formula	s7y	Excel	7	06-05-2013 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:43 AM.