1. L

    Macro or formula to find both unique and un-paired values between two columns

    I'm trying to make balancing my checkbook easier, but finding it hard to find a macro or formula that does what I need. I have two columns, one that has the charges according to my bank, and the other which has charges that I've documented myself. It's easy to find values that occur only in the...
  2. Y


    I have a calculation Problem In My Application In which I need to Calculate Reverse Amount From Grand Total Amount. I Need Logic/Formula for It Need you guys Help. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch...
  3. S

    Excel Formula for Calculating Overdue Charges

    Dear All, Please find the Loan EMI and Collection table below: <colgroup><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col></colgroup><tbody> As per EMI Schedule As per Collection Report Account Number Month Number Sum of EMI Cumulative EMI Due Date Sum of...
  4. S

    Separating lists of data in one cell to multiple rows

    I received a spreadsheet that was submitted from an outside source. I have invoices in one column then the line items of that invoice all in one cell to the right, then the corresponding charges. Is there any way to separate the codes and charges to be in separate cells on multiple rows...
  5. J

    Need help with formula extracting values based on criteria

    So I am trying to find a formula that will pull out unidentified charges from our bank account. I have a list of the known item charges and I would like to create a formula that will list all the items in the description that do not match those charges. So for instance, KNOWN CHARGES: APPLE...
  6. S

    Should i use Lookup or Vlookup to reference a table?

    I sell vegetables to a range of clients. All clients have different charges for different vegetables. My first table is all the vegetables down the left hand side and all the clients along the top with all the charges per item filled in the main body of this table. My order entry sheet i...
  7. A

    Pulling several numbers from a data sheet into another sheet by date/crew/charge type

    I want to fill in a spreadsheet (Sheet A), based on another sheet with data (Sheet B). However, I need it to look for several items at a time on Sheet B and consolidate the totals before entering into sheet A. So, on Sheet B, I have a bunch of data - Carrier, Date, Crew, and a breakdown of...
  8. A

    Costings Formula

    Hi, New to the forum and hoping someone can help what is hopefully straightforward to those in the know!! I'm looking at getting a spreadsheet together to provide an overall percentage cost of a product that has variable pricing depending on the amount paid.... eg: upto £30000 charges 0.40%...
  9. S

    Index Match - want to return ALL matches, not just first match

    I have a table of data like this: <colgroup><col><col><col><col></colgroup><tbody> Annual Charges File # 2012 2013 2014 120 $505.00 $0.00 $120.00 908 $15.00 $1,200.00 $1,425.00 862 $0.00 $0.00 $3,750.00 908 $2,000.00 $105.00 $25.00 </tbody> Notice that there are TWO rows with...
  10. D

    Summarizing data and sorting multiple rows

    I have tried every possible way that I know and I am not half as expert as on this forum.Wondering if any of the experts can please help me The workbook has 3 tabs, one for 2017, one 2018 and the master file. The tabs are the charges which are mostly weekly so lets say for e.g a customer with...
  11. R

    Highlight differences

    Hi All, Thank you in advance, what i need is to be able to highlight the difference between 2 worksheets in the same workbook, fig1 below is sheet1 and fig2 is sheet2. <colgroup><col span="2"><col><col span="2"><col><col><col></colgroup><tbody> fig1 fig2 DEC JAN Desc...
  12. K

    Need Formula fast!!!!!

    I have six (6) spreadsheets with Names and Room #'s and total charges on them. The charges on each sheet are for different items and the names might not appear on each sheet. I want to list the names and Room #'s from each sheet and the charges associated with each name. I only want the names...
  13. G

    VBA Macro - Search and Return Help

    I have a spreadsheet that has data in rows 14 - 797, and columns A through AM. Column B has addresses. The next column of important information is in column D through AM. These columns layout like so: Column D = Landscape Charges, Column E = the z-score for those landscape charges, Column F =...
  14. J

    Currency Format

    hi i have this how can insert this line $ " & Format(Range("b9").Value, "$#,##0.00;($#,##0.00)") into this line of code: strsub = "TNW a/c #" & " " & ThisWorkbook.Sheets("Icube").Range("A7").Value & " " & "and" & " " & " " & ThisWorkbook.Sheets("Icube").Range("A8").Value & ", " & "Credit...
  15. O

    Sumif based on dates not working

    Aug-16 01/31/16 02/28/16 03/31/16 04/30/16 05/31/16 06/30/16 07/31/16 08/31/16 09/30/16 10/31/16 11/30/16 12/31/16 4 months Charges 375,743 393,931 514,907 490,482 480,772 479,377 507,250 465,559 463,607 452,198 389,260 424,965 0 So in this example, Aug-16 is in cell AG1. The 0 is...
  16. P

    "Sum" based on text's string criteria

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, if is possible for anyone of you, I need your support so that to create a vba code, which should “SUM” rows based on text string criteria as my below extract. Should...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back