|
|
#4
02-18-2020, 10:31 AM
|
|||
|
|||
Sure: Your original data starts in cell A2 (student ID). In cell E2 you'll see the formula: =IF(A2<>"",A2,E1) which means "if cell A2 is not blank, then display whatever is in A2; If it is blank then display whatever is in the cell directly above it". In this way the data is displayed correctly as you copy the formula on down to the bottom. Same method in cell F2. Cell G2 is simply whatever is in cell C2. That help?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Filling in cells based on 2 other cells data | Dawindle | Excel | 4 | 11-10-2018 07:40 AM |
 Cells automatically filling in
|
otuatail | Excel | 3 | 08-17-2017 11:31 PM |
| filling in blank cells with data from cell above | RayK | Excel | 1 | 01-12-2017 04:14 PM |
| Filling cells with random numbers using loops? (VBA) | Sajj | Excel Programming | 4 | 04-10-2013 02:29 PM |
|
filling multiple cells whislt using Filter
|
VinceO | Excel | 1 | 05-09-2011 06:38 AM |
Windows 10 
Office 2013
Threaded Mode