Search results

I have a data table with a bunch of transactions showing sales at various times over the past 2 years. I inserted a pivot table and summed up 2018 sales and 2019 sales. I created a calculated item to show year over year growth but it presents as $ along with the sum of the sales. If I change it...

Hi everyone, Is there a way to remove a middle initial from the end of a first name? I have data where the first name fields could be Nathanial J and then the last name field is Smith. Sometimes there's no middle initial there. Sometimes the first name is 2 names (e.g. Mary Anne) so I can't...

Hi there, I have a pivot table with values to include count of leads and count of bookings. I want to have a calculated item that shows conversion rate, which would be ="count of bookings"/"count of leads" but the calculated item is greyed out. How would I do this otherwise, and why is it...

I'm not sure if this is even possible, but I have a bunch of URLs in column A that all start with https://www.mycompany.com/businessline/salespeople and then end differently based on what page they land on. For example: https://www.mycompany.com/businessline/salespeople/jsmith...

Hi, this formula used to work on this report, but the last few months has been returning all zeros and I can't figure out why. (file attached) I'm trying to say if the Fiscal Period is (x) and the agent is (y), what's the sum of sales? I see there are sales so I'm not sure why I'm getting all...

I have a bunch of cells that have absolute references. I want to copy those cells and change only the column part of the cell references (for example, the cell references are $A$1:$A$200 and I want to change them all to $N$1:$N$200). Is there a fast way to do that?

Does anyone know if there's a way to change just one label on the x-axis of a pivot chart? And if so, how? I have 6 labels going across the x-axis: Bob, Sam, Doug, Julia, Ava and Grace. I would like Doug's name to be in red while everyone else is in black, so that when Doug looks at it his...

I have a list of 255,000 email addresses. I need to pull 8% of each domain name and create a new list out from those. I can't figure out a way to make this process easier. For example, I have 48,791 "yahoo.com" and I need to grab a random 3,903 of them; I have 536 "me.com" and I need to grab a...

I know that title made no sense...sorry. I have a spreadsheet that shows trips booked by customers. Customers are identified by a customer number and each trip shows trip number, customer number, booking date, and location. For each unique customer number, I want to show the location of the...

I keep getting this message when I try to copy and paste data from one spreadsheet to another. I'm using Excel version 14.0. What's going on? And how to I fix this?

I'm not sure how to properly explain this, but I have these reports that show account numbers and all the components that are part of those accounts. Each component is on a separate line, but the account number is only on the line of the first component. So, for example, Column A, Row 1 will...

This is weird. I have a column of numbers and I did =sum(d2:d980) and the result is #N/A. When I highlight the entire column it only gives me a count in the lower right corner...it doesn't show average or sum also like it usually does. I highlighted the column and made sure they were all...

I have a column of cells that either say "new", have a number in them (numbers differ), or are blank. I used =countif(a2:a22540,"new") to count how many are new. If I want to count how many are not "new", what's the formula for that?

I was recently upgraded to Excel 2010 so maybe that's why I can't figure this out, but I have 2 columns that contain address information. Column A is 123 Stone Street. Column B is Apt. #4. I want Column C to comibine them into one cell: 123 Stone Street Apt. #4. I tried =concatenate(A1,B1) and...

ARGH! VLOOKUP just *never* goes right for me! I have 2 sets of data on one sheet. The first set is A2:C59833. The second set is G2:J4261. In column H of the second data set I have ID#s. In column A of the first data set I also have ID#s. Both data sets are sorted by ID#s in ascending...

Please help! I have 2 list sets. One shows id numbers and one shows id numbers and a supplier name. I want to look up the values from the first list in the second list and if there's a match, return the associated supplier name. So if I have: column A col B col C ID...

I'm sure this is an easy answer but I'm just not getting it. How do you round a number to the nearest 100 or 1000? For example, if the number is 5798.69 but I want it to say 5700 or 6000, what's the formula? I tried =ROUND(A2,3) but that returned 5798.69 instead of 5700 like I was hoping...

I'm not quite sure I understand how to use the CHOOSE function. I have 7 ranges, and each range earns a specific discount. A sample of this is: If the product costs less than $2000, discount is $0 If the product costs $2000 - $2999, discount is $50 If the product costs $3000 - $3999...

Hi everyone, first time posting. If I have a group of columns hidden...let's say A:G...and I want to unhide column G only, is there a way to do that without unhiding everything and then re-hiding all but G? And is there a different way to do it if the column I want to unhide is in the...