abc

A few questions that I'm having some difficulty with, the 1st and 3rd questions are formula assistance. 1) Current formula (embedded in a text box): =ASVIEW!$AR$9 - I need to update this formula to SUM all values from AR9 through AR16. How would I go about updating this formula? 2) In Excel...

Hi, I have a range of numbers at A2:A10. Column B shows the progressive sum (e.g. B2=A2, B3=B2+A3, B4=B3+A4 etc). Column C will either be blank or have a certain text "ABC". I would like the progressive sum result at column D instead of B with some criteria. I need a formula at D2 which I can...

Hi All, Can someone please help me on below formula. I am trying to add +1 if order number and store number (any one) value are different but if both values are same just use above number. =IF(OR(C3=C2, B3=B2), A2, IF(OR(C3<>C2, B3<>B2), A2+1)) RA NAME PO 4525 ABC 2001 4525 ABC 2001 4526...

Hi, I would like to find a data which is in the left side column of the lookup data. EXAMPLE Col A Col B Col C XYZ 123 12.3% ABC 345 15.2% EFG 105 10.3% I would like to pick up the data in col A for the maximum...

I need to indicate in the rows of column C where the the first duplicate value of Column A is when Column B is not blank. Any ideas? See below example <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Column A Column B Column C 12345 abc X 12345...

Hi all, This is a challenge, at least for me. What I'm trying to achieve is the following: I've a big list of items with several specs. I want to project the matching items (with the same specs) in columns after the item to match. Simplified example of the data: <tbody> Item Spec 1 Spec 2...

Hi I have a workbook that has data in columns A-E. Depending on what data it is in column "A" is has the word "ABC" or "TAB" and then columns B-E all the specific data. What im trying to do is if poss via a macro look all the way down the workbook for entries in "ABC" and "TAB". The...

Hi, I've got a table with a unique ID and some text columns and some numbers for each month. <tbody> Unique ID Text 1 Text 2 Apr May Jun 567926 ABC zafads 5 5 5 704740 DE fadf 5 5 5 704765 DE aafds 5 5 5 506511 DE adfa 5 5 5 705258 DE adfa 5 5 5 705259 DE afd 5 5 5 705260 DE...

I need help with VBA code that will complete the following tasks: 1. On my “Leases” worksheet find all rows with the word “Yes” in the IN_DEFAULT column (column F) and copy those rows A through J. example "leases" worksheet <tbody> FILE_TYPE FILE_NUMBER CASE_TYPE SUB_TYPE OPR IN_DEFAULT STATUS...

Hi Experts, Sorry for wastage you valuable time for my critical issues! as a HR staff, i need to calculate actual staying time if he intermittent input in my organization for example <tbody> Name of Organization Period ABC Company from 3 October 2010 to 25 January 2014 XYZ...

Hi all, Trying to figure out how to do this, even a long winded way if anyone has any ideas. <colgroup><col><col></colgroup><tbody> Company Spend Category ABC Gas ABC Electricity DEF Water ABC Electricity </tbody> I have something like the table above and the end goal is to calculate...

Hi, below I created a simplified version of two worksheets I have. I'm trying to create a formula in Sheet2 that will find the 1st instance of the fund# in Sheet1 B:B, get the value to the left of it in A:A, offset that cell by the amount of rows between that cell and the 1st instance of...

I am trying to retrieve contents of a cell in another sheet based on the contents of that sheets adjoining column as I want to find the data in sheet (ABC) based on the contents of sheet (ABC') column (C) if c1= U then display contents in cell (a1) in sheet(ABC) to sheet (DEF) (K14). I need it...

I have the following column values Input Account no Code 000005678 ABC 000005678 EDF 000001234 ABC 000001234 ABC Desired Output Account no Code 000005678 ABC 000005678 EDF 000001234 ABC Criteria Concatenate Column A and B (i.e...

I have been doing some research but was unable to find exactly what I am trying to achieve. I have been working with VBA frequently but am not quite advanced enough yet to do do this, so I would really appreciate some help! I have a list of customer bookings, with various information and a date...

Hi folks, I want to do a pivot table based on credit card transaction data that is categorized - obviously the raw transaction data won't make for a very good pivot table since it's not categorized... When downloading a credit card stmt in csv I get transaction data something like below (blank...

I am trying to get my table to look like table 2. Any help would be appreciated. <tbody> Name Address Insured Address Policy Policy2 John Doe 123 ABC ST 123 ABC ST 8888A John Doe 123 ABC ST 123 ABC ST 9999B MIKE A 345 CCC ST 345 CCC ST 5555C MIKE A 345 CCC ST 345 CCC ST...

Is there a way to combine results in excel? Survey was sent to ppl in different countries. Survey has dropdowns for each question. Responder will answer all questions. Format of the survey Question - Name of Responder - Company - Location - Dept 1 - Dept 2 - Dept 3...

Hi there, I'm trying to average column that only contain number (and ignoring zero) but I still dont get the right formula. I tried with (=average(if(ISANUMBER(A1:A10000),A1:A10000))) but it doesn't work. Here is the table. <tbody> A 12-Dec-18 X A 11-Mar-19 ABC 89 0 B 5-Apr-19 X...

hello i am trying to write a formula to identify unique enterprise IDs associated with an employee. table below. i don't know where i am messing up, if somebody could advise. Column BH is where the formula is <tbody> Column E Column L Column BH Employee Officer Code Enterprise ID Unique...