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
    105

    Re: Comparing figures against target formula

    Can you post some sample data?
  2. Replies
    1
    Views
    89

    Re: Monthly Weekly Daily Target Turnover

    I've made a sample sheet for how I would build it, see if it suits.


    https://www.dropbox.com/s/hxorrvxvqvszlwa/Monthly%20weekly%20Target%20turnover_koamei.xlsx?dl=0
  3. Re: Convert a vertical task list into a timeline (horizontal)

    I'm guessing where you have actually moved your data to, but it's possible. This setup may run slow and a smaller search area to hyperlink to maybe better if you have problems.

    Here is a link for...
  4. Re: Convert a vertical task list into a timeline (horizontal)

    Hi Daand,

    If a formula version is ok maybe this, just drag this formula across and down as many total rows you think you will need;

    This also assumes that you don't have a main topic & sub...
  5. Re: Create a macro to unprotect sheet, refresh pivot table, reprotect sheet

    Make a test copy of your file & try;


    Private Sub Worksheet_Activate()
    ActiveSheet.Unprotect Password:="850"

    thisworkbook.RefreshAll

    ActiveSheet.Protect Password:="850"
    End Sub
  6. Re: Formula or VBA for a Scroll bar to match min and max values of a variable cell?

    Hi,

    Does this suit?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  7. Re: Index Match with multiple criteria not using arrays

    Hi Ben,

    It's always better to try and add an exception to the formula so that it reduces the rows that it looks at instead of whole columns...
  8. Replies
    3
    Views
    86

    Re: Last recorded date formula ?

    Hi Gaz,

    Assuming your data is in A & B Columns, use CTRL - SHIFT - ENTER to enter the formula as an array;

    =MAX(IF($B$6:$B$12=A1,$A$6:$A$12))
  9. Replies
    1
    Views
    58

    Re: Excel Tables - Pasting in New Data

    Yes it will automatically expand & contract with data that is pasted. I always paste as values when copying from another sheet or workbook.
    Note that if you reference rows or columns from that table...
  10. Replies
    2
    Views
    123

    Re: Average With Data Hidden NOT WORKING

    Hi,

    I'm not sure about hidden columns but you could use criteria to exclude?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  11. Re: Organizing tasks and schedules with forulas

    Hi,

    So how many days do you need to show tasks on the calendar tab? a chosen week or fortnight?
  12. Re: Force print area - does not change when hiding cells??? Help

    It may be easier to extract the info to a new sheet for printing?
  13. Re: SUMPRODUCT formula making spreadsheet run REALLY SLOW!

    Hello,

    I would make a sample copy of your workbook to test, note that all the formulas have Table references so the data on the Complete tab needs to be converted to an excel table;

    ...
  14. Re: Value VLOOKUP is searching for is negative - returns #N/A

    =VLOOKUP([@Aisle],Sheet1!A:C,3,0) is working for me with Aisle as text or numbers, on the same sheet or different sheets.

    Is there possibly any accidental spaces in the Aisle data? maybe check the...
  15. Re: MAX(IF and MIN(IF not giving results expected

    you're welcome

    AND boolean logic uses * between 2 arrays for True & True in ($J$2:$J$28226>G5)*($J$2:$J$28226<h5< font="">)
    </h5<><h5< font="">
    IF(then IF(cut the array in half.


    </h5<>
  16. Re: MAX(IF and MIN(IF not giving results expected

    Maybe this?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  17. Re: I am trying to match the exchanged rate based on the date of the sales data and convert the currency to GBP, Then make a pivot table to show sales from different sources.

    Here's a mock-up version of your sheet, see if it suits.

    https://www.dropbox.com/s/dk6qsgkj5r3l9ui/Excel%202%20MATCH%20SUM%20Problem_JP.xlsx?dl=0
  18. Thread: vlookup help

    by RasGhul
    Replies
    1
    Views
    131

    Re: vlookup help

    Hi,

    Assuming that the total hours worked is from column 4 & user ID is column 1 on the finger print lookup sheet.

    This worked for me, adjust the ranges as needed;

    =IFNA(INDEX('FINGER PRINT...
  19. Replies
    1
    Views
    98

    Re: Barcode scanning application

    Hi Rafi,

    So when you scan a barcode does the barcode number appear in the selected cell?

    If you had an SKU list of all your data including rack locations you could do a lookup for the product...
  20. Re: Extract dynamic list from a range without filters

    Can you post some sample data to work from?
  21. Re: SUMPRODUCT formula making spreadsheet run REALLY SLOW!

    You're welcome thanks for the feedback
  22. Replies
    4
    Views
    157

    Re: Modify SumIf formula

    Hi Willow,

    Adjust ranges as needed;

    Yesterday
    =SUMPRODUCT(('Workorder Search Export'!$F$2:$F$13=TODAY()-1)*'Workorder Search Export'!$G$2:$G$13)

    Current Month
    =SUMIFS('Workorder Search...
  23. Re: copying data from one sheet to another providing a specific condition is met

    Hi,

    I like to lock down the ranges and avoid IFERROR on arrays where possible as it normally can show sheets down, maybe this construction may help you.

    Just adjust the ranges as needed;
    ...
  24. Re: Matrix Table - Add Column to the end of the Matrix (not on every column)

    Hi,

    Maybe this might suit, the dates in the first row will always show today's date minus 5 days, I added the array to populate a unique client list for the matrix sheet;

    The index & match for...
  25. Replies
    2
    Views
    71

    Re: Automatically change Average cells

    You can do that with a pivot table or array formula based on date, can you post some sample data?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4