-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
erick
-
B
conditional formating dates
Hello to all, trying to get cells in a document if any date is filled in Erick- bohon79
- Thread
- cells date document erick filled
- Replies: 1
- Forum: Excel Questions
-
B
Drop Down List
Hello, Wanted to know if anyone is having issues with drop down list and is there a way to fix it. I have a drop down list that works but when I save it and closed the sheet and then reopen later on the data in the list changes. I have it look at a column but the data changes to looking at a...- bohon79
- Thread
- data drop erick list reopen
- Replies: 3
- Forum: Excel Questions
-
B
N/A
Hello, I have a code in a cell that looks at another cell and based on what is in there it autofills the cell in. below is the code that currently works: =INDEX(PERSONNEL!$A$2:$A$20,MATCH(HQS!B6,PERSONNEL!$C$2:$C$20,0)) But when I have nothing in the cell (B6), Cell (A6) comes up with n/a...- bohon79
- Thread
- blank cell code erick n/a
- Replies: 3
- Forum: Excel Questions
-
B
Counting
Hello, having an issue with a counting code. below is the code: =IF(ISNUMBER(SEARCH("ASGN",A20:A24)),"1","0") the problem I am having is that If I only look at one it works, if I try more than one then it does not add those cells together. am I missing something Erick- bohon79
- Thread
- add code counting erick missing
- Replies: 1
- Forum: Excel Questions
