excel & lookup & search

  1. K

    Excel list to show changes in working schedule

    Hello, I need some help with a query. I have a big employee list (from HR system) showing all the different types changes in the record including changes in weekly working hours, this means some employee could be on the list multiple times (with the same unique employee ID) if they have more...
  2. D

    Trying to sort dynamic table in order of number value of first column (this column contains duplicate values)

    Hi, I have a dynamic table that I'm trying to sort by the value of the cells (that have duplicate values) in the first column A. I would start of with this: <tbody> Column A Column B Column C 3 cat Cats Rule#1 3 cat Cats Rule#2 3 cat Cats Rule#3 1 dog Dogs Rule#1 1...
  3. H

    comparing values in a column against multiple sheets and returning subsequent values from other columns

    I am looking for a more sophisticated query to compare values of a column in a sheet against multiple sheets and if the value is found return values from a different column. I was able to achieve this with iferror and vlookup but i have about 20 sheets to compare values against. Sheet1...
  4. V

    Calculate a cell value based on a specific string in a separate cell

    Hello, The first column contains a string of values as mentioned below . In 2nd column, I need to strip out specific info from Col 1 (as mentioned below). I tried using a formula like this - =LOOKUP(MID(AS2,12,3),{"Lar","X-L"," Sma"},{"Large","X-Large","Small"}) , but its not calculating the...
  5. G

    Structured vs Explicit cell reference using index match issue

    I'm using Index-Match to match Full Names with head count in that party. I have it working but it uses both the structured and explicit cell reference. I can't figure out why when I add a new row in my table, the column with the index-match formula wont populate the last row. This is the formula...
  6. S

    Using Indirect inside "Index - Match"

    Hi All, I have 2 workbooks; one has got data in multiple tabs and each tab has a different name. The second one has only 2 tabs; second tab has a table in which first 2 columns contain info about the type, tab name. from 3rd column, it will be month wise data like Jan-19, Feb - 19, Mar-19...
  7. M

    How can i mark empty celles who is not contains any data

    Hi, I have an excel sheet where i want to put a mark on. After that i will extract those data on the line to a new sheet. It is difficult to explain but take å look at the file. The number is å productnumber, second is description, third is the product price, the fourth is the number how many...
  8. M

    How can i mark empty cells who is not contains any data

    Hi, I have an excel sheet where i want to put a mark on. After that i will extract those data on the line to a new sheet. It is difficult to explain but take å look at the file. The number is å productnumber, second is description, third is the product price, the fourth is the number how many...
  9. P

    Exceptions formula

    I have a data set where I am trying to create a formula for each work order that does not have a specific task ("Task 5" Below Table) within the work order based on specific customers that must have this task with their work. There will be customers that do not apply and will not need this task...
  10. E

    I need a simple solution for my requirements without using VBA

    I have multiple excel workbook files with the same format, like column A1:A2-" payer id " column B1:B2-"payer name" column C1:D1-"payments" column C2-cash payment column D2-Credit payment. Each excel workbook gives different month payers & their payments. and the payers also repeated in the...
  11. U

    VBA Browse a File and Get Certain Data

    Hi Team, So I usually work on a particular task where i need to collate specific data. I need to produce a sheet where it has 5 columns in it namely ID, Name, Note, Source and KEY columns. I was thinking of using Getopen file were it will openthe source sheet which is normally in xls or xlsb...
  12. H

    How to calculate business hours/minutes between two dates?

    I'm trying to calculate business hours between 7PM and 7AM. For Example I have a below dataset Start time <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family...
  13. R

    Drop down list with specific condition..

    Hi , I have three columns like Inside/Out side Fixture description replace fixture Inside here is drop down list of fixture This column gives you the drop down...
  14. S

    Calculate interest on loan given at various date with moving libor rate

    Hi All Looking forward for your advice and help in calculating interest on loan given at various date. Details as below a) I have below data as loan disbursement date during the period <tbody> Party Date of Loan Loan Amount A 3-Jan-2016 $ 1,500.00 B 3-Jan-2016 $ 200.00 C...
  15. P

    Index/match type function that matches partial entry with a data set and spits out the general category

    I ran into another issue while trying to solve something else. I have a table of subcategories and general categories that i would like to be able to match to as close as possible to the general category. There are two parts to this issue. One is that the cell where the table will be matching is...
  16. S

    Need to highlight matching rows (or) non matching rows

    Hi, In my excel, i have two sheets. in sheet1, i have three columns with almost 3000 rows. in sheet2, i have two columns with 230 rows. sheet2 was like a child sheet, all these data exists in sheet one. i need to exclude non matching data from sheet one. the condition i have is, two...
  17. T

    Count the first non-zero Consecutive Cells until another 0 appears

    Hi, I'm trying to figure out a way to count the number of cells in the first non-zero Consecutive cells. Been reading all the posts about consecutive cells posts, but couldn't get anything working. Could anyone help? Thanks in advance! The desired results are listed below <tbody> A B C D E...
  18. B

    Vlookup of two sheets

    i have 2 sheets, in sheet 1 i have a site appering more than 1 time under site id colum with different enrty in collo response. i want the entry on a single coulmn for the unique entry in sheet 2 e.g sheet 1 SHEET 2 COLUM A COULM B...
  19. S

    finding a text of 2 words in wrapped content in cell from another sheet

    Trying to find text of 2 words like city and state "dallas, TX" from sheet2 in sheet1 ColumnA(anywhere in wrapped text) example of text in Sheet1 columnA Robert is living in dallas, TX with his aunt. I tried vlookup but it only search exact text in cell not somewhere in wrapped cell...
  20. S

    Fetch matches from a file based on its corresponding ID list in second file?

    <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...

Some videos you may like

This Week's Hot Topics

Top