help in need

Hello all-- Wondering if there is a way to pre-format a pivot table for an analysis template I'm working on. I have a data template tab titled Raw Data and in column M is my Origin State to track a shipment. The range that I'm working with is M3:M20002. The goal I am looking for is to be...

Hello, I have the following VBA code set up to work the same as a sumif, but I need to be able to utilize the concatif formula under multiple criteria, i.e. Sumifs. Can this be expanded as such? Function ConcatIf(ByVal compareRange As Range, ByVal xCriteria As Variant, Optional ByVal...

I'm about to pull my hair out over this one step in my homework. I've read my assigned textbook chapter on Goal Seek, Scenario Manager, etc... but trying to plug the problem from my instructions into goal seek isn't proving successful. Here's the exact wording: "Use Goal Seek to determine the...

Hello, I am looking for a way to sort the current data of stocks a company holds in order to update the prices of products using the given updated data from the supplier. An example of the current data I have and the solution I am looking for is provided in the links below: links removed by...

<tbody> Patient Name (or Id) Vaccine Name date of vaccine Sally Smith Mumps 5/17/13 Sally Smith Rubella 5/17/13 Sally Smith Measles 5/17/13 John Doe Mumps 5/17/13 JohnDoe Measles 5/17/13 Sally Smith Measles 6/4/1990 </tbody> Hi everyone...

Hi, I have been trying to record a macro to do the following: 1. Create a new column (always before the last column of the table) 2. Drag the formula from the previous column to the new one. Example: Columns: A, B, C, D, E Need to create a new column always before the last column (E) so...

ok i have a sheet that looks like this and all i want it to do is this... <tbody> frist date of birth email jan. feb mar apr may jun jul aug sep oct nov dec eric 1/30/1986 eric86vabeach@yahoo.com *read note* bob 2/15/1990 bob@bob.com *read note </tbody> ok in cell...

Hey Guys How do i program the following formula? VALUE OF PROPERTY: TRANSFER COST 0-600 000 ______________0% 600 001 - 1 000 000 _____ 3% of value exceeding 600 000 1 000 001 - 1 500 000____ 12 000 plus 5% of value exceeding 1 000 000 1 500 001 and above_____ 37000 +...

Hi All I have a spreadsheet with 2000 rows of information, What i am trying to do check the Numbers column if the cell values match and set the first time of call to 0 i:e the 0 to represent the initial call and then work out the time difference between additional calls in the time bucket...