~~~ PSA ~~~
Off Topic is NOT the Software - Apps, Programming and Games forum.
AnandTech Moderator
---
Hello guys,
I didn't get much response in the "Software-Apps" category page, thought there maybe more people reading the Off "Topic" page
Here is my question,
I need to have a formula in Excel where it should be able to detect the amount of duplicates in one data range
say S/N: abc123 found in location A3,C2, and H4, the column with the formulation should be able to give me like "abc123--3"
in the previous thread, thanks to power engineer, he suggested a line of code for me.
but that only works for one column of data to compare with one specific entry
example in column D10:-
=IF(LEN(C10)>0,IF(COUNTIF(C$1:C9,C10)>0,C10 & " -- " & TEXT(COUNTIF(C$1:C9,C10)+1,"0"),""),"")
how do I do it in a range? arrays needed for this?
i tried looking online but there are functions for "MAX" and "SUM", but I am not sure how to even use them to tackle this issue
any help from computer wizz out there?
Off Topic is NOT the Software - Apps, Programming and Games forum.
AnandTech Moderator
---
Hello guys,
I didn't get much response in the "Software-Apps" category page, thought there maybe more people reading the Off "Topic" page
Here is my question,
I need to have a formula in Excel where it should be able to detect the amount of duplicates in one data range
say S/N: abc123 found in location A3,C2, and H4, the column with the formulation should be able to give me like "abc123--3"
in the previous thread, thanks to power engineer, he suggested a line of code for me.
but that only works for one column of data to compare with one specific entry
example in column D10:-
=IF(LEN(C10)>0,IF(COUNTIF(C$1:C9,C10)>0,C10 & " -- " & TEXT(COUNTIF(C$1:C9,C10)+1,"0"),""),"")
how do I do it in a range? arrays needed for this?
i tried looking online but there are functions for "MAX" and "SUM", but I am not sure how to even use them to tackle this issue
any help from computer wizz out there?