|
|
#5
07-30-2023, 07:03 PM
|
||||
|
||||
With Excel 2016 you have Power Query (aka Get & Transform Data) built in. All you'll need to do is to update the table on the left with your few hundred rows of data, then right-click somewhere in the table on the right and choose Refresh.
As to a formula for column E, quite difficult, but maybe possible with a slightly different Power Query query. I'll have a think on it. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Range method Find can't find dates
|
jmcsa3 | Excel Programming | 1 | 05-02-2020 06:56 AM |
| How do you use the find and replace tool to find dates and times in Excel 2013? | Jules90 | Excel | 3 | 04-14-2020 07:40 PM |
|
Pictures overlapping eachother on the same slide
|
kaiks | PowerPoint | 1 | 11-03-2015 08:50 PM |
|
Find and Replace: Dates
|
Attirb | Word | 2 | 04-13-2011 09:56 AM |
|
Lots of overlapping appointments!
|
MushyPeas | Outlook | 2 | 01-21-2009 10:01 AM |
Windows 10 
Office 2021
Threaded Mode