# abc

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

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...