I have below sample table that has Time and Employee ID, what I need is to calculate total hours viewed by individual ID. I sorted the ID already but in real data I have thousands of rows without any kind of sort and I need to make it easy for me to calculate time spent by employee every...
I managed to use below formula to ignore blank and it worked, what I need now is how to get the top 20 or any top (any figure). I'm using below table as an example data:
Formula I used : =UNIQUE(SORT(FILTER(Sheet1!$CQ$15:$CS$7241,Sheet1!$CR$15:$CR$7241<>""),3,-1))
Real data range in my...
I would like to format a range of cells in Column "B".
I would like to use VBA to set the conditional formatting however, each cell will have slightly different formulas.
For example. I want to change the color of the font for each cell that has a value of 0.
So if B2=0, then the font in B2...