Jun 8, 2020 ... It lists names in two separate columns (last and first). I would like to merge these cells into one cell, and add a comma between them (ex: Doe, ...

May 10, 2022 ... I am trying to create an audience segmentation model and am aiming to add the relevant segment name to a sheet of customer data using ...

Jun 15, 2020 ... I would like to total up the overall scores (Column L) for each duplicate name from the DATA sheet onto a separate sheet so that I can create an overall leader ...

May 20, 2019 ... If the first and last names (Col's A and B) don't match can I have it retrieve Col's A,B, and C from sheet 2 and add them to sheet 1? #2 Would ...

Dec 20, 2021 ... Then, each time I add a name to one of the three columns, the pivot table will continue to automatically update the count and add additional ...

Mar 21, 2020 ... I've been attempting to do is compare Sheet1, Column G with Sheets 2, Column A and when there is a match sum up the corresponding values in Sheet2, Column B.

May 21, 2019 ... You could use sumif but query is a natural for this. It had to be two queries instead of one because you have calculated columns in the middle.

Mar 9, 2021 ... Hi, I made this copy of your sheet and put in 3 formulae that reproduce the output (see highlighted cells) but they are very specific to the ...

Mar 13, 2020 ... I put the IF in there so that if you don't have a name it won't put in a bunch of cells with just the commas and spaces (", , " ). If this is ...

Oct 4, 2021 ... I'm trying to automatically find those columns and count the cells containting text and put them together in a different sheet.

Oct 29, 2020 ... I will then be adding email addresses in manually. I need the formula to update any new names automatically, but for any email addresses I've ...

Nov 10, 2022 ... I want to create an auto fill list that will also put in the accompanying address and other categories when I choose the name.

May 10, 2020 ... I have z table with several columns. Col A and B contain names. How do I filter table as follows: show me only rows that col a OR column B equal ...

Aug 12, 2021 ... These are the two trouble columns. When I type any other column in I get data with no errors. I have tried both SUM and Custom settings to no ...

Mar 22, 2022 ... I have a workbook that has multiple names in it. I need a formula that will count how many names are duplicated but they are not all in the same column.

May 28, 2020 ... ... spreadsheet with names that have both first & last in the same column. ... That should give you two (or three) columns with First and Last Names.

Jun 15, 2021 ... In the "CASES" sheet, this is where I store a weekly snapshot of all last week's imported data and I add my additional columns with more pieces ...

Dec 12, 2020 ... My intention is to inform any user that those two columns are the output of a formula, showing data that exists in another location. Names and ...

Oct 11, 2023 ... ... different parts, but usually somewhere in the ... Instead of referencing cells directly, you can name a whole column as a Named Range.

Jun 12, 2021 ... I have two name fields (First Name & Last Name) and want to ... I entered the formula into cell J1 in your spreadsheet. ={ "Result ...