| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula returns blank cells--only want values to show
I am trying to link data from one worksheet to another using the IF formula.
The first worksheet (roster) includes student information, status (active or inactive) and assessment units completed (designated as Y or N for each unit). The subsequent worsheets include the data for each unit. With the help of Max--I used the following formula in the second worksheet to return a value only if the student was active and had completed the unit: =IF(Roster!$A9="I","",IF(AND(Roster!$A9="A",Roster !$H9="Y"),Roster!B9,"")) However, if a student is inactive (I) --a blank cell is returned. Is there any way for the values of only the active students (A) to appear on the worksheet sequentialy (without the blank cells)? Your help is greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif returns blank if all cells blank | Excel Worksheet Functions | |||
| Formula to find equal values with blank cells | Excel Discussion (Misc queries) | |||
| sum of blank cells returns zeros | Excel Worksheet Functions | |||
| Formula that returns Col A data in Col B, but omitting blank cells | Excel Worksheet Functions | |||
| How do you nest the following formula to show blank cells | Excel Worksheet Functions | |||
Threaded Mode
