Sep 07 2022 07:39 AM
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 |
Sep 07 2022 07:57 AM
Sep 07 2022 07:57 AM
Sep 07 2022 08:38 AM
Sep 07 2022 08:47 AM
Sep 13 2022 05:36 AM - edited Sep 13 2022 05:39 AM
So far none of the suggestions worked particularly on a larger scale
Sep 13 2022 05:52 AM
Sep 13 2022 10:12 AM
@Patrick2788 Ok but does MS take a full workbook? How do I do it?
Sep 13 2022 10:44 AM
Sep 13 2022 02:35 PM
If you don't see an option to attach a workbook, upload it to a cloud service such as OneDrive, Google Drive or Dropbox, obtain a link to the uploaded workbook and post that link in a reply.