Search:

Type: Posts; User: RasGhul; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    159

    Re: Problem with formula

    Hi

    It looks like sumproduct may be more useful here, can you post some sample data so we can look at it?
  2. Replies
    1
    Views
    123

    Re: Booking Tracker

    Can you post some sample data?
  3. Re: months from 1 to 12 in columns (in numeric format) not sorting correctly in a pivot

    Is yr source data real dates?

    highlight your month numbers in the pivot and sort options/manual sort.

    you should be able to change the order in the pivot.
  4. Re: Sum If a Pivot Table Data Set Based on Date

    If you convert your source data to a table we can use sumifs with table referencing to be dynamic;

    e.g =sumifs(table1[AP],table1[Week Ending],"<"&B12)

    Right click on your sheet tab for your...
  5. Replies
    4
    Views
    209

    Re: Rank using 3 criteria

    Try

    =SUMPRODUCT((COUNTIF($F$3:$F$22,"<"&$F3)+(COUNTIF($I$3:$I$22,">"&$I3)+(COUNTIFS($F$3:$F$22,$F3,$M$3:$M$22,">"&$M3)+1))))
  6. Replies
    1
    Views
    81

    Re: Scheduling in Excel

    I would use the =NETWORKDAYS(startdate,enddate,[Holidays]) function to filter workdays.

    There are plenty of decent youtube videos on gantt charts if you look around.
  7. Replies
    2
    Views
    162

    Re: Project Workplan Dashboard

    I know its not VBA but maybe this helps.

    I used an array on the data prep tab to extract Project Names greater than 0 only. Then pointed the data source for the Projected vs Actual at the data...
  8. Re: Issue in sum of positive amount & Negative Amount

    When I used =ROUND(SUM(B1:B4),0) the result was 0.
  9. Replies
    1
    Views
    93

    Re: Adding formula to excel table

    Make sure the auto format option is working,

    Navigate to Options/Proofing/AutoCorrrect Options...(button)/AutoFormat as you Type;

    Tick all boxes including "Include new rows and columns in table...
  10. Re: Automating pulling data from several sheets into a master sheet

    Hi Younis,

    A formula solution would be difficult to make dynamic and maintain, if VBA is ok you can try this.

    I'm not sure if it will handle data with blank rows and make sure to test on a...
  11. Replies
    9
    Views
    241

    Re: Transactions Per Hour

    Muz can you post your formula for sa7toot as well pls mate?
  12. Replies
    9
    Views
    241

    Re: Transactions Per Hour

    Can you post some sample data, so we can check it out for you.
  13. Re: Sum If a Pivot Table Data Set Based on Date

    It might be easier to SUMIFS on your data?


    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  14. Replies
    1
    Views
    46

    Re: Date Subtraction using business days

    =networkdays(b2,a2)
  15. Replies
    2
    Views
    88

    Re: saving hyperlinks between Workbooks

    When you use standard hyperlinks it hard codes the current workbook/sheet referencing with it.

    You could use hyperlink formula instead so that is dynamically changes with your workbook name. e.g....
  16. Re: Select Value from dropdown list and display the range of cells from the worksheet

    You're welcome.
  17. Re: Select Value from dropdown list and display the range of cells from the worksheet

    Is this what you need?

    If I understand your goal correctly you can do this with a hyperlink formula, setup in this fashion you can enter target column & rows, the dv dropdown list of column G is...
  18. Replies
    1
    Views
    105

    Re: excel hyperlink issue

    You could use a dynamic hyperlink formula based on your index & File names;

    Can you post some sample data?
  19. Re: Creating a map chart with England areas only

    Hi NJ,

    I've used this technique before as a good work around for map charts.

    https://www.youtube.com/watch?v=EoKoN1q2cTk
  20. Re: Combine data into limited quantities efficiently

    Can you post some sample data?
  21. Replies
    1
    Views
    514

    Re: First date within 2 tables

    Can you post some sample data?
  22. Replies
    6
    Views
    312

    Re: Manual Sales Report Help

    I've freed up the formulas on the convert tab, and I also needed to have my PC on US Date Region, date format mm/dd/yy. When I reverted my PC back to my region & format the date formulas result in an...
  23. Replies
    4
    Views
    198

    Re: IF AND OR Formula

    Maybe try;

    =IF(AND(OR(E2="VIC",E2="NSW",E2="QLD"),A2>100000),">100000",IF(AND(OR(E2="NSW",E2="SA"),A2>160000),">160000"))
  24. Re: INDEX/MATCH & SUMIF (with one and/or two comma separated reference numbers)

    Can you post some sample data?
  25. Replies
    6
    Views
    312

    Re: Manual Sales Report Help

    Hi Chris,

    We're now returning Lite Server ID Numbers and ignoring rows that have blanks in the payment types/receipts overview.

    I would recommend using the Convert & Output tabs to extract the...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4