# Formula for Extracting Data

Occasional Contributor

# 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

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 65.06 97.49 225.34 126.1 69.57 94 65.04 97.49 225.34
12 Replies

# Re: Formula for Extracting Data

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?

# Re: Formula for Extracting Data

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

Maybe with FILTER.

# Re: Formula for Extracting Data

@budspwr1933 Can try SORTBY() function.

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

# Re: Formula for Extracting Data

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

# Re: Formula for Extracting Data

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

# Re: Formula for Extracting Data

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.

# Re: Formula for Extracting Data

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

# Re: Formula for Extracting Data

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

# Re: Formula for Extracting Data

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.

# Re: Formula for Extracting Data

I did the best I could!

# Re: Formula for Extracting Data

Well, I hit the go button.

# Re: Formula for Extracting Data

Let me know if it got there.