level

  1. S

    Vlookup with row index?

    i made a formula for column index to find Average value so i have used this formula 1)i have huge data which are in row index ex:ch 7+800,7+825,7+850.....9.800 in column A1,A5,A9...up to 9.80. if we have in column B2,B3,B4 have levels then which formula i have to use to caliculate average...
  2. T

    Automatic Part Number Generator

    Hello all, First time posting here. I'm trying to create a part number generator in Excel. The part numbers are in the following format: "XXXXX-XX", where the first five digits are serialized numbers, and the trailing two digits are the revision level. When a new part number is pulled, the...
  3. K

    Adapt file to show data for any given date

    Hi! Let me apologize for the vague title but the one thing that i'm looking for I don't even know if it has a technical name -which limits my ability to google it-. I have a file with 22.000 rows and these are the headers for each column: SERIAL NUMBER LOCATION_MONITORING LEVEL EFFECTIVE...
  4. P

    Flow down information based on project number

    Hi all! I have an Excel sheet where I want to flow down information based on a cell value. My Excel spreadsheet contains a list of project numbers in two levels (always the base level which contains project information, and level 1 which doesn't contain that information). The list I have is a...
  5. S

    SI function incrementation

    Hello everyone, I have an excel table (see the link at the end) and I would like to automate the incrementation of column C, I tried this function but there is still a malfunction: = SI ($ B5 = "success", REPT ("0", 4-NBCAR (NB.SI.ENS ($ B $ 5: $ B5, $ B5, $ A $ 5: $ A5, $ A5) .SI.ENS ($ B...
  6. M

    Removing Duplicate key and selecting one record based on each id

    <colgroup><col span="2"><col><col></colgroup><tbody> (A) User ID (B) Username (C) Highest Education Level (D) Qualification Obtained 1001 1001 Postgraduate Certification 1001 1001 Bachelors Degree 1001 1001 Masters Degree 2001 2001...
  7. M

    Array formula returns just one number everywhere

    I must be doing something wrong...but I came through all the manuals on the web and I am doing it exactly the same how it should work. I have a table. And for each person (name) and each level, I want to get the maximum value from the column "number". So if I select the whole range in column...
  8. R

    COUNTIF and Named Cells

    I have a feeling I'm missing something obvious. I have some data in columns, where folk have a number that indicates their skill level (0, 1, 2 or 3) in a task. e.g. Name Level Jane 3 Bob 2 Emily 2 Rona 0 Molly 1 Brenda 3 I want to use COUNTIF...
  9. K

    Flip Coin

    I need Excel to select a value depending on a random coin flip. The values are: 5, 10, 15, 20, 25, ... through 95. The beginning number is always 10. If the coin returns tails the number returned will always increment one level (plus 5, but never greater than 95). If the coin returns heads the...
  10. P

    Looking to find duration at different levels

    Hi, My data is as follows: <tbody> Name Date Level John 1/1/2015 1 John 1/23/2015 2 John 1/30/2015 2 John 2/5/2015 3 Bill 1/12/2015 1 Bill 1/15/2015 2 </tbody> I'm trying to easily see how long each person was at a given level. For example, from the above, I see John was at...
  11. K

    Which rows have the same value in Column A and a certain value in Column B?

    I have two columns, one is an ID# for a particular institution submitting data and the other indicates the type of institution level. An institution might have submitted more than once and each submission is a new row. I want to know if each time the institution submitted, the data is missing...
  12. J

    Grouping rows between data headers via VBA

    Hello, long time lurker, first time poster. I have an SAP output that is organized into levels in column A. Level 00 is the project level additional levels/sublevels (01, 02, 03, etc) make up the work breakdown for the project. Then, there are multiple projects in the same sheet. An example...
  13. M

    editing link sources w find replace without having to manually define the source

    How to use find replace to edit the source from ='S:\Reports\[Report 201712.xlsx]High Level Summary'!$A$7 to ='O:\Reports\[Report 201712.xlsx]High Level Summary'!$A$7 AND.... not have excel prompt me for the source each time,... that is for each cell with the link. I've used find and replace...
  14. K

    Using module to retrieve/call multiple sheets

    Hi, does anyone know if you can use the codes from module to call/retrieve multiple sheets. I have created a quiz(game) and I wanted to add "level difficulty" in my quiz. For example, Users can choose to select level 1(beginner), level 2(advanced) and so on from the home page(user form) of the...
  15. kc.crow

    Hierarchical counts - multilevel

    Have an interesting problem. I suspect that this may need to be resolved with code but if there is a nifty array formula that would be even better. Here's a sample set of data A B C Mgr Emp Y/N M1 A1 Y M1 A2 Y M2 A3 N M3 A4 Y M5 A5 N M1 Y M3 M2 Y M7 M3 Y M2 M4 Y M3 A6 Y M2 A7 Y M5...
  16. E

    Force 2 levels in nested subtotal?

    Edit: Nevermind, my mistake, sorry! I'm actually on Excel 2002, and I'm running into a bug. http://support.microsoft.com/default.aspx?id=833855 or http://support.microsoft.com/kb/831824 When I do nested subtotals, I find that it groups levels differently for the second subtotal if the group...

Some videos you may like

This Week's Hot Topics

Top