How to search cells that are blank and copy the last cell above

[shegre]

What formula can I use that searches through an array of cells and checks if the cell is empty or not. If the cell is not empty it returns the value in that cell. If the cell is empty it copies the cell above it that is not empty.

The first cell that is checked will never be empty.

 

[shegre]

I am trying to build a report in excel for each agent that requires data from another worksheet.

I need a formula that checks if the agent ID is equal to 1341, and if the agent name is equal to Agent 1, and if a call code is equal to 0 in Report 2. If all these are true, then copy the total time in column F of Report 2 to column E, row 2.

I thought I would try and explain what I am ultimately trying to accomplish to see if there is a better way than the way I was originally trying.

 

[T. Valko]

I am trying to build a report in excel for each agent that requires data from another worksheet.

I need a formula that checks if the agent ID is equal to 1341, and if the agent name is equal to Agent 1, and if a call code is equal to 0 in Report 2. If all these are true, then copy the total time in column F of Report 2 to column E, row 2.

I thought I would try and explain what I am ultimately trying to accomplish to see if there is a better way than the way I was originally trying.

I think I may be following you on this.

However, the format of your report #2 is not conducive to easy data extraction.

If you could fill in the empty cells for the ID# and the agent name so that it's like a flat file database then what you want to do should be fairly easy.

Book1
	A	B	C	D	E	F	G
2	1341	Agent 1	177:15:15	2	Break	1	0:00:42
3	1341	Agent 1	177:15:15	0	No Reason Code	104	34:53:02
4	1342	Agent 2	0:18:53	0	No Reason Code	1	0:00:07
5	1343	Agent 3	148:42:48	4	Meeting / Con. Call	1	0:00:04
6	1343	Agent 3	148:42:48	2	Break	2	0:03:13
7	1343	Agent 3	148:42:48	3	Coordinating / Dispatching	1	0:00:04
8	1343	Agent 3	148:42:48	0	No Reason Code	93	110:04:50
9	1343	Agent 3	148:42:48	6	Project	1	0:00:04
10	1343	Agent 3	148:42:48	1	Finishing Call	1	0:00:05
11	1343	Agent 3	148:42:48	5	Voicemail / Email	1	0:00:03
12	1346	Agent 4	167:32:24	2	Break	1	0:59:40
13	1346	Agent 4	167:32:24	0	No Reason Code	99	26:26:50
14	1349	Agent 5	35:09:46	0	No Reason Code	26	6:59:52
Sheet1

 

[shegre]

That is what lead me to my original question of how to search those empty fields and copy the cell above it to fill in the blanks.

 

[T. Valko]

That is what lead me to my original question of how to search those empty fields and copy the cell above it to fill in the blanks.

That's really easy. See this:

http://contextures.com/xlDataEntry02.html

 

[shegre]

That worked, thank you so much! I will be submitting another post on how to copy some of the data from report 2 to report 1 as I am still struggling with that part.

 

[T. Valko]

That worked, thank you so much! I will be submitting another post on how to copy some of the data from report 2 to report 1 as I am still struggling with that part.

Good deal. Thanks for the feedback!