While doing my Christmas list, I thought of putting everything on excel file so I won't miss the number in my inventory of gifts once I assign these gifts to names. However, the task/equation I needed was out of my league so I asked an officemate to help me. Now, I learned a new thing in excel which I think is worth sharing :)
#-countif(range,"value") --> e.g., #ofgifts-(A1:D12,"gift1")
countif(range,"value") & "," & countif(range,"value") --> e.g., countif(A1:D12,"gift1") & "," & countif...
No comments:
Post a Comment