Forum Discussion

wanalearn's avatar
wanalearn
Brass Contributor
Sep 02, 2022
Solved

Is there a formula or function ?

see attached    I want to have in column A ''Names'' and one column the  Regular values another column  Over Time values etc. if I do it, by creating a table the values don't match the correct names...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Mar 14, 2023

    wanalearn  It appears 2 things:

    a) it appears you have cases that have more than 1 instances of the same category in the same group.  I changed the formula to be a SUM() of the FILTER result to prevent that error

    b) some of the "values" are actually TEXT so I added a "--" in front of the FILTER to force numbers that look like text to be converted to numbers but that will break if actual text like "n/a" or "zero" or what not is in there.

    see attached

     

     

mtarler's avatar
mtarler
Silver Contributor
Mar 14, 2023

wanalearn  It appears 2 things:

a) it appears you have cases that have more than 1 instances of the same category in the same group.  I changed the formula to be a SUM() of the FILTER result to prevent that error

b) some of the "values" are actually TEXT so I added a "--" in front of the FILTER to force numbers that look like text to be converted to numbers but that will break if actual text like "n/a" or "zero" or what not is in there.

see attached

 

 

Resources