Tzippy
Tzippy
Discussions
- I need to count how many cells there are in a column IF that cell contains one thing AND does not contain another thing. I can do one or another but having trouble combining it. So far I have this and…
- I have a "name" column and a "HRC code" column and want to find duplicates in each column. The following formula works just fine for the name column but it wont work for the HRC Code column I believe …
- I'm stumped. I have a column called "code" on two sheets. I'm trying to flag the rows on sheet 1 if the code isn't found on sheet two. I feel like it should be simple but I keep getting error messages…
- I have two sheets with the following 2 columns. column 1 - HRC code column 2 - status The HRC code will always match on both sheets but the status may be different. Sheet 1 will have the most current …
- Good morning! I have each of the following formulas in a separate cell and works just fine. However, I need it all in one cell but cannot seem to figure it out without getting error messages. Hoping s…
- For some reason I cannot use a subtraction formula when pulling the info from a column that has an existing formula. Is that a thing or am I doing something wrong? I'm using the simple formula below =…
- I cant figure out why this formula isn't working and am hoping someone can help me. I have a discipline column, a current date column and a in service required column. based on the time of year and di…
- I'm having trouble. I want to do a cross sheet VLOOKUP and return the value from another column ONLY if its no match. Details: I have a "HRC code" column and a "status in HHAX" column on sheets 1 and …
- I have each of the following formulas in a separate cell and works just fine. However, I need it all in one cell but cannot seem to figure it out without getting error messages. Hoping someone can hel…
- I'm trying to figure out how to return a name from a dropdown if the date in the date column is within the next 7 days.
