Forum Discussion
Fomula issue
Hi All, Can someone take a look at my formula and help me understand why the cells in column L is not taking the information correctly? Could it be a formatting problem? Thank you in advance. ...
I believe that was it. Now I get an error message that states "Inconsistent calculated column formula"
Bahama85 That just means that the same calculation is not in all rows within the table. If you copy and paste in all rows that should disappear.
Cool, got that far but nothing is showing up as expected in the cells. No errors in the cells.
 
 
Bahama85 Okay, that last zero in your formula , if you recall, needed to be a 1 instead of zero which designates the index column of the array.
You're making progress. 🙂
- Ah yes, so I changed it to a )),1,"") but nothing changed. Cell L6 should reflect Q6 as 639.
And thank you, already going to look into some excel classes so I can come back with more challenging questions for you wizards.