my aswer is this

  1. H

    #Value Error

    I create statement sheet, which have Debit (H), Credit (F) and Balance (G) Column. Both Debit (H) and Credit (F) have Formulas to to calculate them Values. In Balance I make this Formula, =IF(ISBLANK(C8),"",H7+F8-G8) I use IF(ISBLANK just to keep the cell blank if there are no Data in that raw...
  2. F

    How to use SUM function to get specific value

    Hi Excel Gurus, Is there any option to add the columns to get particular value. Lets say for example as below: 500 500 500 500 150 150 Can we able to get only 300 as result by adding this column.
  3. F

    How to Reconcile two values splitted in multiple rows in same column

    Hi Excel Gurus, How to Reconcile two values splitted in multiple rows in same column In the below example you may see, for each day, we have same amount in two columns but these amount are splitted in third column, how can we match these. Any suggestions. Example: <colgroup><col><col...
  4. E

    Macros Copying & Transposing Specific Cells Across Multiple Sheets into Summary Sheet

    I'm trying to build a macro to pull/copy the same specific cell ranges across multiple worksheets onto a summary sheet. Apologies for my incompetence but I'm new to VBA and on a short timeline so any help is appreciated. I have one workbook with ~200 identical worksheets (all with different...

Some videos you may like

This Week's Hot Topics

Top