Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to fill in fields when cell is blank
Hi
I have a spreadsheet that I contains duplicate applicants with same acct number. I need to make a table by column to identify how many applicants to a loan. Sample of dats Acct. name 123. Joe Jim I want to create another column to say if A2 is blank then use field a1. Then in another column I want to say applicant 1 and applicant 2 My output would look like this Acct. applicant 1. Applicant 2. Now by date is row format Acct. applicant 1 Applicant 2 Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to fill in fields when cell is blank
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to fill in fields when cell is blank
ty thats is fine for me, too
Am 10.10.2013 09:14, schrieb : Hi I have a spreadsheet that I contains duplicate applicants with same acct number. I need to make a table by column to identify how many applicants to a loan. Sample of dats Acct. name 123. Joe Jim I want to create another column to say if A2 is blank then use field a1. Then in another column I want to say applicant 1 and applicant 2 My output would look like this Acct. applicant 1. Applicant 2. Now by date is row format Acct. applicant 1 Applicant 2 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill in blank cell | Excel Programming | |||
Fill blank cells with an if formula? | Excel Worksheet Functions | |||
Fill cell that is blank | Excel Worksheet Functions | |||
formula to populate while skipping blank fields | Excel Worksheet Functions | |||
Fill with a formula until Cell is Blank | Excel Programming |