Forum Discussion
IF Formula trouble
Hello,
can you add your excel file? and describe what you want to achive? As I have understood you have C and I colomns with some values. and you want to look for names where there is 1 on the correspondig cells in C and I column? Is it correct?
Yes, but when those values are found it then lists the names from column a in the cell and the cells below it. Ill try and make a simplified version as there is a lot of data in the sheet I am using and post it.
do you have to do this with formula? the easiest way is to use a pivot table. filter the data and get required data with getpivotdata function. or you can use Pivot Table as it is.
I have never used a pivot table but if it can get me what I want that is fine. I have made a very simple version of sheet. Column a is name, b is info a and c is info b. In column F, I would like a list of names that have 1 for both info a and info b. My original formula listed the names but with only one condition, info a.
Thank you.
Here is the pivot table version. You can create a table for your main table if you wish. Which will allow a dynamic range which means the range will expand whenever you add some data. and then refresh pivot table to reflect the changes. hope this helps.