Formula for Extracting Data

Copper Contributor

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

12 Replies
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?

@budspwr1933 

=FILTER(M2:R4;A2:A4=MAX(A2:A4))

Maybe with FILTER.

filter.JPG

 

@budspwr1933 Can try SORTBY() function.

=INDEX(SORTBY(P2:U4,A2:A4,-1),1)

Harun24HR_0-1662565121548.png

 

 

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

@budspwr1933 

So far none of the suggestions worked particularly on a larger scale

If you're able to upload a sample workbook, it will help you get a quicker solution. There's plenty of people willing to help but some don't have enough time to do the legwork of building a sample.

@Patrick2788   Ok but does MS take a full workbook?  How do I do it?

Click 'Open full text editor' below the compose box and it may then give you an option to upload.

@budspwr1933 

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.

I did the best I could!
Well, I hit the go button.
Let me know if it got there.