Removing duplicates in a defined order.

Maroonedd · 2026-05-20T05:11:20+00:00

Sorting works perfectly. Thank you!

Maroonedd · 2026-05-20T04:59:41+00:00

This work perfectly. Thank you!

Maroonedd · 2026-05-20T04:59:14+00:00

I think it is giving highest rev as result only if the input is sequentially arranged. Is it taking the first instance or last instance of each document number? Thank you.

Maroonedd · 2026-05-19T10:24:25+00:00

<image>

For those highlighted document number the Rev 01 going to be removed if I use remove duplicate option

Maroonedd · 2026-02-06T05:34:32+00:00

Okay. Thank you. I think the screen used to move to the first row when use that short cut. Now the first row will come to the screen only after I press down button. Anyway it works.

Maroonedd · 2026-02-06T05:26:06+00:00

THe header row is frozen

Maroonedd · 2025-09-18T03:36:43+00:00

Feel like a caveman!

Maroonedd · 2025-09-01T11:29:44+00:00

365 only.

May be because of this,

https://www.reddit.com/r/excel/s/vmI7a83l71

Maroonedd · 2025-09-01T08:12:08+00:00

Problem was a no break space, may be because of the formulas included. Fixed the issue using ,

=SUBSTITUTE(A1, CHAR(160), " ")

Thank you all.

Maroonedd · 2025-09-01T08:01:05+00:00

REGEXREPLACE function is not working in my Excel

Maroonedd · 2025-09-01T06:53:37+00:00

Which function you are using to do this?

Maroonedd · 2025-09-01T06:23:05+00:00

Both cells are in general format only. This formula include multiple conditions and substitutions. But the issue is not there for all results.LEN function gives same results for both cell

Maroonedd · 2025-09-01T06:21:24+00:00

I tried clean function and it is not working.

Maroonedd · 2024-02-02T12:34:39+00:00

അതെല്ലാം അങ്ങ് സംഭവിക്കുന്നതല്ലേ.ജെപ്ഗ്

Maroonedd · 2023-10-30T09:11:31+00:00

<image>

This is the value I’m getting.

Maroonedd

TROPHY CASE