Search results

Thanks F106dart. I'm still new in using macro so can you help me modify the arguments. I tried to modify it as far as I can but I can't seem to make the macro run. My file have 3 worksheets, data source, dashboard, and calculation. In the calculation worksheet, i have one pivot table which...

Hi, I need some help on pivot tables. I have 2 different pivot tables in 2 different worksheets with similar data reference. These 2 both have "Week No." and "Monthly" report filters. If I choose specific value for "Week No.", then the "Monthly" filter should have "(All)" value and vice-versa...

also, i tried this formula: =IF(B2=MAX($B2:$G2),INDEX($1:$1,1,MATCH(MAX($B2:$G2),$B2:$G2,0)),"") now my problem is how to match the second occurence in the row. hope you can help me on this. thanks in advance luke! :)

i simplified the formula to: =IF(B2=MAX($B2:$G2),INDEX($1:$1,1,COLUMN(B2:$G2)),"").. seems working though. honestly, i'm having problem with your index formula and i can't seem to figure out how to fix it. i only used the INDEX formula now so i'm still exploring how to actually use it. the...

Thanks Luke. I revised the formula a bit and use this formula instead. =IF(B2=MAX($B2:$G2),INDEX(1:1,1,IF($B2=MAX($B2:$G2),COLUMN($B2:$G2),COLUMN(B$1))),"")

Hi, Below is the format of my excel file. Basically, I have skills in the first column and the suceeding columns are rating (1 lowest and 5 highest) of each person on a particular skill. I have several skills in line but i only listed some for the sake of this sample. What I want to do is to...