-
I teach data analysis using pivot tables in a short course and we usually need to use lookup functions such as VLOOKUP in order to import fields from different data tables into another one before building a pivot table to get the desired analysis results. Sometimes, VLOOKUP is not an appropriate choice...
-
Hey I want know if excel can sort data while leaving spaces between the groups. Basically I have 3 groups of data that need to be sorted alphanumerically but they need to be kept in their respective groups seperated by 1 row. If I cant do that is their a ascii charater or something that i can put into...
-
Hi all, I need to generate task ID #s using a formula. Easy enough. However , the users now want to sort by the task ID #s. When that happens, the task ID #s change, because the formula that generates them continues to refer to cells that no longer have the appropriate data in them---that data has been...
-
Hi. I need help with a type of counting problem. I have a huge excel data file with over 50,000 data entry points. It is forex data. I have a list of several banks. And their trade dates, and a bunch of other information columns that are cost, volume, what currency traded in, and more complicated diagnostic...
-
I have the following data strings in each cell: M1.M17.M49.M203.M205, M1.M17.M78.M190, M1.M4 I need to separate the data after the last period in each cell. I am using: =RIGHT(H2,FIND(".",H2)-1) but get only the last two digits in each case. Help!
-
Is there anyone there that can assist with an elegant and accurate way to calculate the age of a person using the current date stored in one cell and a person’s birthdate in another cell? I am trying to calculate and display a person’s age in years only as of the date entered into the Current...
-
Hello, I have two spreadsheets that I'm looking to link together through a VLOOKUP or similar type function. The data I'm trying to reference is all laid out uniformly on the spreadsheet pages, although the pages have names that are not as simple as S1, S2, S3 - I am always going to be referencing...
-
I have 3 sheets in my excel document. The first one is the main form and the other 2 are summaries that need to be populated and distributed the correct person depending if one value on Sheet1 begins with a letter between A-O or P-Z. What I need on each summary sheet is this sequence: On Sheet 2 in Cell...
-
Here is a typical row in the spreadsheet which is nearly 4000 rows of data: Description WBS WBD Material Qty Mea Size | Ball Valve, V600, 02 | C12DO | F1804B | CARBON STEEL, PIPING | 12 | EA | 1" | Im trying to use the "Description" & "WBS" columns for the criteria to match...
-
Excel 2003. We are capturing grades for site reviews based on the scale listed below. On the report we need to indicate how the current grade compares to the grade from the previous period. Score Grade 1 F 60 D- 64 D 67 D+ 70 C- 74 C 77 C+ 80 B- 84 B 87 B+ 90 A- 94 A 97 A+ If the grade improves or declines...