johnson

Hello, I'm looking for help in creating a macro to summarize a member database by Address. This is to get our mailing address list from our member database. Any help on how I can accomplish this would be greatly appreciated! Example Data (Sheet 1): <tbody> First Name Last Name Address City...

hello everyone, tried doing with dax and regular excel methods but scratching my head here is a table example. the "style" number is repeated because there are multiple vendors that source the product. i simply want to concatenate each of the vendor names together separated by a comma. how...

If I want to count how many days someone worked based off the name in column B and the Day of the Month in Column C what kind of formula would I need? <colgroup><col span="3"></colgroup><tbody> <colgroup><col span="3"></colgroup><tbody> A B C Ticket Number Name...

I have a list of over 75,000 names. I am trying to get a unique count of any cell that has special characters in then except the comma (,). For the data below the count could be 7. Thanks in advance! Billard, Ny'aniah S.D. Kolman, Ja'Niyla A'Marie Johnson, Dave Holmes, Lord-Ken'th Hook-Boullai...

I have a number of cells and I am looking to remove the duplicate strings (2 characters or more) in them. Is this possible with an existing Excel formula(s)? It's ok if I need to use helper columns (C, D, E...) For example: A1 = Jane & Bob Smith Smith A2 = Joe Johnson Johnson A3 = Sally and...

When I input a formula in a cell, it is randomly updating other cells in different columns with no apparent links. I have gone through and deleted all external links, I've reviewed all formulas to make sure they are manually removed, and I've gone through charts and shapes to make sure there...

Aladin Akyurek We discussed Lookup and Find a while back. Formula returned required values but I just noticed today formula is returning incorrect values when I delete data from row 23. Row 23 previously had: 23A Johnson, 23B John 23C 18,000.00 Could you advise please? Excel...

Note: I tried to search but I am so naive that I don't even know what to search for. Snippet: https://i.imgur.com/mqaFGRp.png Two Parts 1. I want to be able to type "Dustin Johnson" (B2) in another cell (let's say 'Z1' for example) and have the value in the final column (B13) appear in 'Z2'...