Search results

Good Morning All, In the attached below, I would like to make the table on the left look like the table on the right by having a formula that looks in Column A and finds "Hershey's Total", extracts "Hershey's" and places it in C2-C5 leaving C6 blank. Then the formula would extract "Nestle" from...

Hello, I am looking for VBA code that would find the blanks in the QBRat column and delete those entire rows, e.g. Matt Ryan and Matt Cassel and then find the last row in the spreadsheet and calculate the Pct column down to through that last row. (Comp / Att * 100 = Pct). Thank you in advance...

Hello, I am looking for VBA code that would find the blanks in the QBRat column and delete those entire rows, e.g. Matt Ryan and Matt Cassel and then find the last row in the spreadsheet and calculate the Pct column down to through that last row. (Comp / Att * 100 = Pct). Thank you in advance...

Hello, I have a source sheet with data. I would like to create a new sheet that would utilize certain columns from the source file and I would like this new sheet to update automatically as new entries are made on the source sheet. Is there an easy way to do this? I have attached an example...

Hello, I have never used VBA before so I am totally unfamiliar. I am looking for VBA code that would find certain text and replace it using a reference table so that the code knows what to replace the original text with. I have attached an example doc where the "Reference" tab provides a table...

Hello, I have a column of first names and middle initials. What formula could I use to extract the first name only? Thank you in advance for any assistance, leimst

Good Afternoon, When referencing a Pivot Table, can someone tell me the difference/advantages/disadvantages between using the "GETPIVOTDATA" formula to refer to the pivot table and grab the data versus simply using a Copy and Paste Link? Thank you in advance for any assistance, leimst

Good Morning All, I'm struggling with a Conditional Formatting formula. I have a spreadsheet with a "Manager" column that has a dropdown in it. The problem is that often the users "Cut and Paste" their entries thereby by-passing the restrictions that the dropdown list is trying to impose. Is...

Good Afternoon All, I have recorded a macro which I attached to a forms button but when I emailed the spreadsheet to the end user, the macro was not functional because it is saved in my Personal Macro Workbook, Personal.xlsb. Is there a way to save it to just this particular workbook so that...

Good evening, Surely the answer to this question is already posted out there somewhere and I am just phrasing my "search" incorrectly. Anyway, I have a spreadsheet with over 37,000 rows and want to insert a column where the first 200 rows read "P1" in column A, the second 200 reads "P2", the...

Hello, I have the following data: Date Merchant Code Amount Separate Merchant Code List 5/23/2012 5712 $25.24 4596 6/24/2012 5963 $15.21 8521 7/15/2012 2541 $12.00 2541 8/6/2012 8512 $32.65 3657 7/6/2012 7532 $56.45 1254 4/22/2012...

Hello, I am comparing 2 columns row by row attempting to identify where values in any given row do not match. I wanted to use conditional formatting and the formula "=A2<>B2" through the end of the spreadsheet, e.g. "=A100<>B100" so that Excel would highlight in red those rows...

Hello, I have a spreadsheet where the data is associated in pairs...so 2 columns at a time. For example: A B C D E F Old Date New Date Old Time Stamp New Time Stamp Old Cost New Cost Is there a way to highlight 2 columns at...

Hello, Is there a concise formula that would look at the number of digits in a number and insert the necessary number of zeroes required to bring the number of digits up to a certain length. An example would be that I have a column of what should be 10 digits numbers. However, some of the...

Hello, I have a pivot table with sales information by manager. It seems like I recall that Excel has the ability to generate a separate pivot for each one of the managers at the touch of a button which results in additional tabs in the workbook that would be labled by manager. Am I making this...

Good Afternoon All, I have 2 lists of names, each on it's own tab. Some names are on both lists while other names are only on one of the lists. I would like a formula that would look at each of the lists and return a cumulative list of names with no duplicates. Any help would be greatly...

Hello, Does anyone know of a good way to share PivotCharts with Sliders to others who do not have PowerPivot installed? Thanks for any help! Leimst

Hello, As an example, if I have the following data in A2:A15, 65 54 25 36 59 36 12 65 84 87 65 36 36 25 If I use Countif($A$2:$A$15) I get the result of 4 but if I execute the Countif as an Array formula, I get 3 as a result. Can anyone explain why this is the case? Thanks for...

Hello, Is there a keystroke I can use to return a cell's display to the original formuala after pressing F9 and getting Excel to show me the results of the formula? After hitting F9, I've not been able to figure out how to revert back to be able to view my formula once again. Thanks in...

Hello, I inserted a table in excel so that subsequent rows carry the formulas with them. However, when I password protect the sheet the table no longer behaves as a table and the little blue triangle in the last row and farthest to the right column no longer appears. Is it not possible to...

Luke,somewhere along the line I ran across a link where you did a great job of explaining array formulas. Could you possibly send that to me please? I'm still trying to get a grasp on how they work. Thanks!! Leimst

Hello, I am using an Offset command in the "Refers To" line of the Name Manager in order to create a dynamic Named Range, e.g. =OFFSET('Dropdown info'!W$2,0,0,COUNTA('Dropdown info'!W:W)-1,1). However, I originally input the formula as =OFFSET('Dropdown info'!M$2,0,0,COUNTA('Dropdown...

Hello, I have a report that has a column with store numbers in it. I need to come up with a formula that will search through the column and return the store that occurs the greatest number of times within that column. A caveat is that I would like to be able to use it on other spreadsheets...

I have a spreadsheet that requires periodic updating from approximately 10 different users. I'm trying to constrain and control their input because I'm finding that they are not following my directions, are adding rows and columns, inputting in the wrong columns among all the usual ways that...