#1
|
|||
|
|||
Formula for creating Account Name
Hello,
Can you provide the formula for creating a column of Household accounts with the naming format: FN LN Household. The FN and LN are in separate columns (Columns E & F), and the word Household is to appear after each FN LN. If there is no value on the FN column, the formula should allow LN to create the account name as: LN Household. The Household accounts need to be listed in Column B - the same column as other accounts. Do I need to create a separate column for Household Accounts and then merge the 2 columns? I need to end up with one column "Accounts" that will contain both Household Accounts and Organization Accounts. I've attached the spreadsheet for your reference. Thank you in advance for your help on this! Gef |
#2
|
|||
|
|||
I inserted another column in D for Account with this formula for the first row of data:
Code:
=TRIM(IF(ISBLANK(F2),"",F2 & " ") & G2 & " " & IF(LEFT(C2)="H", "Household","Organizational")) |
#3
|
|||
|
|||
Thank you!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel formula required to speed up process of creating species rarefaction curves. Ecology! | Tim_F | Excel | 2 | 07-18-2014 04:56 AM |
Creating formula based on if data is correct in cell | MattMurdock | Excel | 1 | 08-06-2012 03:11 AM |
Need help creating a formula for student grade | johnnykhan | Excel | 2 | 04-03-2012 02:28 PM |
[OL2010] Creating a search folder with folders belonging to other POP3 Account | balubeto | Outlook | 0 | 01-07-2011 02:07 AM |
Help with creating a Formula, please | websiteaog | Excel | 9 | 11-25-2010 04:09 AM |