unique formulas

Hi, 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...

Hi, 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...