excel & lookup & search

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

<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...

dear sir ma'am <colgroup><col><col><col></colgroup><tbody> ORDER ID NO OF HOURS TO PICK OR3173JG-002A 90 OR3289CG-002A 71 OR7846FG-002A 87 OR5531NF-003A 24 OR8259UG-001A 99 OR9663UG-001A 77 OR4926VG-001A 69 OR4421UG-001A 90 OR3805DF-002A 91 OR8570UG-001A 5...

Hello Everyone, I have searched for solution for few hours but couldn't find any. I have few text strings of variable length. I would like to extract content of cell that starts with certain specific Character. For Example I have A1:A3 Batman vs superman 4:50 Wonder woman vs Flash 5:60 Batman...

Hello, Please have a look into the below two table. . and assume that 1st one is posting data and 2nd one applied data. I have to verify whether all the posting data are applied or not. If we use Vlookup or Duplicate formula that $2000 will show as applied but i have applied two only. one of...

A colleague is trying to do a time study on how long it should take to hire a new associate. Their spreadsheet data is below. I need to enter a formula C1 to predict the amount of time it would take to hire a group of associates. We assume that 1-3 associates takes the same amount of time, and...

I keep getting the #REF when i copy this vlookup down and have no reason why. Please help, the sheet and cells it is referencing is =IFERROR(VLOOKUP(A16,'Locked Forecasts-DNT'!A2:AI1048576,35,0),"-"), usually works when i manually type it but can't do it any other way. thanks...

Hello there and I require some help to build an excel formula. Situation: I have a column A with names and a column B with dates. In my table there are entries with the exact same name, but of those with different entry dates. I want in column C to identify for each row name duplicates and...

Hi Excel Nation, I am currently working with 2 lists of data on 2 separate worksheets. By using the project ID numbers and the phase specified by the corresponding column, I am trying to return the status of the phases' QA status. For the below example, I want to return the status of the...

I have data in column A and B have lookup data. If the any of the lookup data is partially matching in the result column need to put lookup data. I tried with VLOOKUP but no luck. Please help me. Columns: A B(Lookup)...

I have account codes that look like this #######-###-##-######. After the first (-) ###, is the department code. In sheet "acct_codes" all of the full account codes are listed and in sheet "dept_list" all of the departments are listed. I have a sheet called "lookup", in cell B2 of that sheet...