All Questions
4
questions
0
votes
3
answers
3k
views
Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells
Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells or does not find the lookup value.
I do not want to suppress the zeros by formating them out. I want ...
0
votes
1
answer
177
views
Why does conditional formating "white out" only certain manual formating is some cells?
I'm trying to make a spreadsheet with tables, with some automation, that keeps track of my work hours. (Note I'm not using the Excel "format as table" feature. This is all by hand). ...
2
votes
1
answer
9k
views
How to set the numeric format in Excel so that every three digits have a space for some arbitrary long numbers?
For example, if the format is like this: ### ##0,
the number 1283300 will be formatted like this: 1283 300 but I want to display it like this: 1 283 300
or number 75125690347812567 I want to ...
1
vote
2
answers
774
views
Highlighting Groups of Alternating Names in Excel
I have been trying to find a good way to do this but it seems like I can not find a good Conditional Formatting formula to work with what I need. I am trying to do something along the lines of this ...