Forum Discussion
Formula for Extracting Data
Formula for Extracting Data
I have had a bit of trouble developing a formula to bring/copy data (of the last entry in a column) to another location. Very dependent on the last date of entering data. Some formulas I've tried: @INDEX(A2:A5000<=TODAY()*(U406:U5000),); @INDEX(A2:A5000<=TODAY(),(@U406:U5000));and DGET. Column A has the dates and columns P thru U have the data I want to use. I have 6 columns I that want a specific formula to deal with each column for the last data entry so that I can use the last entry on a medical summary sheet.
I have attempted a number of formulas and DGET is what I ended with. Nothing worked.
Any suggestion will be appreciated. I'll try whatever comes my way.
A B C
DATE | DAY | WEIGHT |
9/5/22 | Mon | 227.2 |
9/6/22 | Tue | 227.2 |
9/7/22 | Wed | 228.0 |
P Q R S T U
Systolic Trend | Diastolic Trend | Oxy Trend | Heart Trend | Temp Trend | Weight Trend |
126.11 | 69.55 | 93.99 | 65.08 | 97.49 | 225.34 |
126.07 | 69.53 | 94.00 | 65.06 | 97.49 | 225.34 |
126.10 | 69.57 | 94.00 | 65.04 | 97.49 | 225.34 |
- What result do your expect from given sample? It seems you have data on all columns. So, last column data should be your last updated data. What is complexity?
- As you see the last row of data is synced with the 9/07/2022 date. This data changes daily. This last row of dated data is to be transcribed to a daily summary sheet given to doctors. The summary sheet represents up-to-date date of a patient. The problem is transcribing last minute data from each column to the summary sheet automatically. Note that the other raw data columns are transcribed to the summary sheet in a different manner
So far none of the suggestions worked particularly on a larger scale
