Home |
Search |
Today's Posts |
#1
|
|||
|
|||
show non-blank as 1
Hi All
I'm running a crosstab query in access, importing into excel and using it to show on another sheet if a step is used or not. The crosstab query counts the number of times the step is used. Example, my first yes shows 8. Here's the formula working on the second sheet. =VLOOKUP(A12,CapModXtab!$A$3:$I$280,3,TRUE) It returns the value, 8 for my trues, blank for false. I'd like the 8's to show up as 1. Is there a way to add that into my formula or format the cells to do this. I was able to change the cell format to yes or no. That would work for me, but people are used to seeing "1" meaning yes we use that step. Thanks! Barbara |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needs to Show blank please | Excel Worksheet Functions | |||
To show blank please | Excel Worksheet Functions | |||
How do I delete extra blank pages at end of doc...only show when. | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions |