Reputation
333
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 6 16
Impact
~103k people reached

  • 0 posts edited
  • 1 helpful flag
  • 28 votes cast
Jul
26
accepted Count rows matching criteria for every row in excel
Jul
26
comment Count rows matching criteria for every row in excel
thanks but "make up my mind" is little unncessary. See my comment above and I don't want to argue on public forum with someone who helped me. Forum is a typo, I meant column. I will try Pivot Table, thanks!
Jul
26
comment Count rows matching criteria for every row in excel
@fixer1234 This is not off-topic. Actually, Google spreadsheet has almost all the functions Excel has. If UNIQUE and SORT do not exist in Excel that's just my lack of usage with Excel, but this question is still very much valid in Excel. In fact I plan to export from Google server; if I don't have Excel handy I will use an online tool. The core question does not change. So no, off topic is the wrong thing.
Jul
26
comment Count rows matching criteria for every row in excel
@telyyn thanks I am actually using Google Spreadsheet (but I plan to export to my computer), I did not know UNIQUE and SORT don't exist in Excel. So there is no real way to build column D more dynamically? It seems like in option 1 I am really telling the forum look at C2, C3, C4, etc"
Jul
26
asked Count rows matching criteria for every row in excel
Jul
13
awarded  Notable Question
Jan
22
awarded  Notable Question
Sep
17
awarded  Famous Question
Aug
16
awarded  Popular Question
Jul
29
awarded  Notable Question
Jul
2
awarded  Curious
May
2
awarded  Famous Question
Dec
10
awarded  Notable Question
Dec
10
awarded  Notable Question
Nov
11
awarded  Popular Question
Nov
3
awarded  Popular Question
Sep
8
accepted Using GParted to convert GPT to MBR without access to an OS
Sep
8
revised Using GParted to convert GPT to MBR without access to an OS
added 107 characters in body
Sep
8
comment Using GParted to convert GPT to MBR without access to an OS
I didn't try this method but it works. I believe your method will work so I will also upvote.
Sep
8
comment Using GParted to convert GPT to MBR without access to an OS
Thanks that works.