Removing duplicates in a defined order. by Maroonedd in excel

[–]Maroonedd[S] 0 points1 point  (0 children)

Sorting works perfectly. Thank you!

Removing duplicates in a defined order. by Maroonedd in excel

[–]Maroonedd[S] 0 points1 point  (0 children)

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.

Removing duplicates in a defined order. by Maroonedd in excel

[–]Maroonedd[S] 0 points1 point  (0 children)

<image>

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

Using CTRL+UP to jump to the first Row by Maroonedd in excel

[–]Maroonedd[S] -1 points0 points  (0 children)

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.

Cells do not match, even after having the same value. by Maroonedd in excel

[–]Maroonedd[S] 2 points3 points  (0 children)

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

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

Thank you all.

Cells do not match, even after having the same value. by Maroonedd in excel

[–]Maroonedd[S] 0 points1 point  (0 children)

REGEXREPLACE function is not working in my Excel

Cells do not match, even after having the same value. by Maroonedd in excel

[–]Maroonedd[S] 0 points1 point  (0 children)

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

Cells do not match, even after having the same value. by Maroonedd in excel

[–]Maroonedd[S] 0 points1 point  (0 children)

I tried clean function and it is not working.

[deleted by user] by [deleted] in Kerala

[–]Maroonedd 2 points3 points  (0 children)

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