Thread
:
Formula to fill in fields when cell is blank
View Single Post
#
3
Posted to microsoft.public.excel.programming
Hermann Maier[_2_]
external usenet poster
Posts: 1
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 With Quote
Hermann Maier[_2_]
View Public Profile
Find all posts by Hermann Maier[_2_]