•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Merge cells dependent on a condition
Our take
To effectively merge cells in Excel based on specific conditions, you can follow a straightforward approach. In your dataset, where the "name" is missing, you can populate it with the corresponding "company" name if it exists. Start by selecting the range of data, then use a formula to check if "name" is blank. If it is, replace it with the "company" value. After making these adjustments, ensure your spreadsheet retains only the "uniqueid," "name," and "email" columns before exporting to CSV.
teat me as a beginning beginner pre-beginner level user
4 columns - uniqueid, email, name, company
I will export to CSV and can import only the first 3 into the program.
Before exporting, within Excel, how would you attack this :
Where name is missing, populate it with the company if it exists
uniqueid,name,email,company 00011,CindyLou Who,cwho@company.tld, 00012,,grinch@company2.tld,Grinchdom 00013,,sally@company3.tld, 00014,Patrick,pat@spongebob.tld,Spongey 00015,,bob@spongebob.tld,Spongey desired:
uniqueid,name,email 00011,CindyLou Who,cwho@company.tld 00012,Grinchdom,grinch@company2.tld 00013,,sally@company3.tld 00014,Patrick,pat@spongebob.tld 00015,Spongey,bob@spongebob.tld [link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Cell merging / formatting formulasThis might be an odd one. I'm not that skilled with excel as my use of in within my job is pretty limited. However, I tend to use this template my predecessor made to summarize data from our program. Works well, just a simple ='SHEET 1'!A1 for all cells. The first two images give an example. After the data is ported, I have to get rid of the zeros between the data and write system names. When it comes to pasting it on letters, the names are bolded, upped a font size, and two of the cells are merged (3rd image) This gets a bit tedious as the lists can get pretty long so I've been trying to figure out how to streamline it on my own. My idea has so far has been to have a separate cell detect when I'm finished adding my data and then format the aforementioned cells (4th image). For the life of me, just can't figure out how to write a formula to do it. What I would need is for the formula to detect a 1 (could be anything) in cell G10. It would then check for any blank cells in columns A and B. Once found, it would merge & center, bold the text, increase the font size, and align right. Is this only possible with a macro? I've been unable to find any formulas that could accomplish this. https://preview.redd.it/853mpr4jspog1.png?width=788&format=png&auto=webp&s=943a34a57f1d7c7f88256dd89b81b9c6fc301e34 https://preview.redd.it/e3w6ms4jspog1.png?width=453&format=png&auto=webp&s=9b189fa77d6638b627f8676dad60bc148753617c https://preview.redd.it/msh6ys4jspog1.png?width=411&format=png&auto=webp&s=d5f5025b315f24fd5f3a64c6e07e019abd3a77ab https://preview.redd.it/7j66tt4jspog1.png?width=936&format=png&auto=webp&s=1faa4df12ee74892f5fa9dc27ac95621280cf3c5 submitted by /u/Extension_Train9093 [link] [comments]
- Complex data sort needed across 3 columnsI have a spreadsheet where I want to return a subset of rows. There are 3 relevant columns: A, B, and I. They are all text values. I want to return all columns where column A="B" ("B" is a person) Of that subset, I want to see all rows where column I does NOT equal "P" ("P" is a location) Of that subset, I want to see all rows where column B's text value "blah" (a task) doesn't also exist as the column B value in the subset of rows where A="B" and I DOES equal "P". In other words, me, a person, am going to location P today, and I want to find out if there is a task that I can do there that hasn't been done there before, but HAS been done at a different location. Thanks! submitted by /u/sowtime444 [link] [comments]
- Gather unique names to show multiple columns as well.G'day team. I am stuck at what should be a simple issue but my brain has gone away on holidays it would seem. I have a csv of events of the previous month which has multiple ID's (col A)that match Suburbs (col B) and postcodes (zip codes) (col C). I am attempting to sort the unique ID numbers to show the matching Suburb and Post Code. I have tried XLOOKUP, UNQUIE, GROUPBY and other Youtube hints but nothing working. I know it will be something simple but my brain is just not working the problem today. The data will be joined with Lat & Long coordinates for inclusion into a GIS report. Any help greatly appreciated. https://preview.redd.it/f67jzgbh5itg1.png?width=316&format=png&auto=webp&s=7c4f7839f66bcb0418762ccce5efeffd0b41f96e submitted by /u/Aussiediver [link] [comments]
Tagged with
#Excel compatibility#Excel alternatives for data analysis#no-code spreadsheet solutions#Excel alternatives#rows.com#enterprise-level spreadsheet solutions#financial modeling with spreadsheets#Excel#CSV#uniqueid#email#name#company#import#export#populate#missing#conditional#data manipulation#cells