abc

  1. B

    Excel Formula Assistance (If Statement w/lookup and SUM)

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

    Progressive summing basing on cell value of another column

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

    Auto Numbering based on 2 columns value.

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

    Reverse VLOOKUP....Is it possible??

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

    Indicate First Duplicate Value in a Column when a condition exists in another column

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

    Find related items based on multiple criteria > index+match multiple criteria or somthing else?

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

    How do I compare data for duplicated and missing entries

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

    Excel Table With Columns Months to Rows With Months

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

    help with vba code to match data on multiple worksheets

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

    Date , time formula

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

    Counting average number of unique outputs

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

    Index/Match & Offset Problem

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

    find contents of one sheet and displaying on another based on contents

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

    Concatenate & Remove Duplicate

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

    Splitting Data into Months based on Date Range

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

    Categorize credit card transaction details by predefined buckets (e.g. gas, food, entertainment, etc.)

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

    Rows with duplicate values merge and delete duplicate keep unique value in row

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

    Combining survey results in excel

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

    Average numbers and ignore text

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

    IF, COUNTIFS Statement

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top