Search results

hi Faseeh, Problem is not in the formula.for int% your formula is 1*(int errors/int resp reviewed) whereas the formula is "1-(int errors/int resp reviewed)".I have specified this formula in first sheet.Manually,i'm doing this from a year & results are correct.i just wanted to make it more...

hi Faseeh, Results are not correct.Their score can't be more than 2. Please experts help me on this. Regards, SG

Hi Faseeh, I wanted to make calculated filed in pivot.however,i firstly tried out your way.I want to reduce sheet size as manually mapping the formula makes sheet heavy because data is in thousands.anyways.thanks for looking in to this.

hi Experts, I'm trying to replace a manual mapping by using calculated field in pivot.however, it's not giving me the correct result.can anyone please look in to this & give me a more better solution.please help me.I have uploaded a sample file at below location:-...

the targets are in %. So i want to see them as they are.% can't be sum,avg,max, min. Thanks for the reply.I try.

Hi Experts, I'm again with new type of confusion. Can i use vlookup within pivot table as calculated field or any other way.Actually i want to lookup the team targets from base sheet in pivot table.I do this manually by applying vlookup in helper column.I want all to be in one table...

Hui, For normal CF,it would adjust, my case is for icon sets.

Hi Narayank991, I have already checked this link.This doesn't solve my purpose.

One by one,it can be changed,my concern is this when i copy the format to no. of cells, they are not pointing to their adjacent cells.

ohh sorry....I mean to say CF in C3 & C4 still points to the values in A2 & B2 which should point to their adjacent cells.

Hi Hui, PFA at belw path https://hotfile.com/dl/163886849/7617182/Conditional_formatting.xlsx.html & look for the cell c2 & c3 formatting which doesn't go with their adjacent cells

First i select the icon sets & choose Rule "Format all cells based on their values".say i have to apply it in cell A1 based on values in B1 & C1.Then in "value", i give "$B1" as reference & so on for next icon & in "Type" as "number".Then Excel gives the error for not allowing relative referncing.

Hi kaushik03, I need to copy the format to all the cells in the range based on the values in the adjacent cells.

Hi Hui, Thanks for the welcome.I really learnt alot from chandoo's forum.Really appreciate starting such forums. Now,for the problem,When i write $B1 ..it says for icon sets, excel doesn't allow relative referencing.

Hi Guys, This is my first post in the forum with a very silly question for all experts but a problem for me.In Conditional formatting, i'm using icon sets of 3 arrows.say i'm applying it in A1 based on values B1 & C1.When i drag it to A2, it still points to $B$1 & $C$1,however it must pint to...