|
|
#1
11-13-2018, 03:28 AM
|
|||
|
|||
Formula to get text from multiple cells in Excel 2007
Hi guys
I have a table in excel 2007 and one of the columns is with dates I need a formula to lookup the current day (today) in those columns and for every time it finds a match to get the text from a cell on that line. For example if I have the table below BMW 11.11.2018 Opel 11.11.2018 Audi 13.11.2018 Skoda 13.11.2018 Lets say the today date is 13.11.2018 I need the result in a cell to be Audi Skoda Any ideas ? Thanks 
|
|
|
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode