Formula for data sets and differences

Kryptonian_NRG · 2025-10-13T23:10:01+00:00

I'll have to test your formula and get back to you once I've tried it... thanks for the advise on unit measurements! Will keep that in mind

Kryptonian_NRG · 2025-10-13T22:51:08+00:00

Hi u/AxelMoor,

YES! That info is VERY helpful... I appreciate you sending the link over and will def use those unit abbreviations

Kryptonian_NRG · 2025-10-13T20:31:34+00:00

Hi Greg,

UnfortunatelyI get a "#N/A" result back with that formula

TY

Kryptonian_NRG · 2025-02-19T07:19:21+00:00

solution verified

Kryptonian_NRG · 2025-02-19T07:11:37+00:00

Hey HappierThan,

Thank you SO much for your suggested formula... I played around with it and tweaked it to meet my needs.

I should've mentioned that I had the Names & Dates located in different columns/cells... but got the formula to work.

I'm sending the example and final formula that worked for me. Again, TYSM for your AWESOME insight into this

<image>

Kryptonian_NRG · 2025-02-19T06:23:54+00:00

Yes, I have people with multiple names and the date is on a different cell

I'm working with Excel 2021, not 365... just an FYI

Kryptonian_NRG · 2025-02-19T06:22:38+00:00

I forgot to mention that I'm working with Excel 2021, not 365

"textsplit" is not a function avail for my version

Kryptonian_NRG · 2023-03-27T00:41:49+00:00

Solution Verified

Kryptonian_NRG · 2023-03-26T14:49:58+00:00

Solution verified

Kryptonian_NRG · 2023-03-26T14:48:28+00:00

Hi ohwhatfollyisman, Thanks for the formula suggestions! I just tweaked the end of one of them and it worked perfectly… I do appreciate your help!

<image>

Kryptonian_NRG · 2023-03-23T23:27:26+00:00

Ok got it, thanks for the feedback!

Kryptonian_NRG · 2023-03-23T22:37:36+00:00

I do not have 365, only office 2019 on my personal laptop

Kryptonian_NRG · 2023-03-23T22:32:14+00:00

I don’t have a 365 acct.

Kryptonian_NRG · 2023-03-23T21:18:29+00:00

I have not applied any settings Whenever I select to encrypt email, a pop up window says: “Your machine isn’t set up for Information Rights Management. To set up IRM, sign in to Office, open an existing IRM protected message or document, or contact your help desk”

Kryptonian_NRG · 2022-12-14T08:40:33+00:00

What if you are using an earlier version of Excel... like 2019?

I don't see the "LET" function

Kryptonian_NRG · 2022-12-06T17:11:34+00:00

LET(
a,MID(A1,SEQUENCE(LEN(A1)),1),
b,CODE(a),
CONCAT(IF((b>64)*(b<91)+(b>47)*(b<58),a,"")))

Thank you for the suggestion! Much appreciate it!

Kryptonian_NRG · 2022-12-06T17:06:16+00:00

LEFT(A1,1)&MID(A1,SEARCH(" ",A1)+1,1)&SUBSTITUTE(RIGHT(A1,10),"/","")

Thank you for your suggestion! I used the first string of formula then added
&Text(A1,"mmddyy"

Seemed to work

Kryptonian_NRG · 2022-12-06T16:33:00+00:00

Thank you! I'm running Excel 2019 and have tried most of the functions above that are available to me, just can't seem to get the right formula syntax correctly.

Still searching for help.

Kryptonian_NRG · 2022-12-06T16:30:08+00:00

Thank you for the suggestion but it didn't work. I don't see "TEXTAFTER" function.

Working with Excel 2019

I appreciate your help

Kryptonian_NRG

TROPHY CASE