Search:

Tag: offset formula

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. OFFSET formula for dynamic range

    Started by Stuepef‎, 04-23-2024 11:39 AM
    counta, dynamic range, dynamic range for row, offset formula 1 Attachment(s)
    • 55
    Last Post: 04-23-2024 01:46 PM
    by Estevaoba  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] SUM, FILTER using a dynamic range to calculate Year to date (YTD) data

    Started by dxfoxd‎, 03-26-2024 07:42 PM
    filter formula, offset formula, year from date, year to date 1 Attachment(s)
    • 123
    Last Post: 03-27-2024 06:19 AM
    by dxfoxd  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Creating a combo chart with dynamic information

    Started by DawnG1231‎, 07-22-2022 09:32 AM
    analytics, chart, data, dynamic, offset formula 1 Attachment(s)
    • 562
    Last Post: 07-22-2022 10:40 AM
    by 6StringJazzer  Go to last post

    Forum:
    Excel Charting & Pivots

  4. [SOLVED] Having trouble inserting OFFSET() as variable twice in formula

    Started by Techgique‎, 03-24-2022 02:08 AM
    nest formulas, offset formula, reference error
    • 287
    Last Post: 03-24-2022 01:14 PM
    by Techgique  Go to last post

    Forum:
    Excel Formulas & Functions

  5. INDEX + MATCH + OFFSET + SUMPRODUCT formula for Forecasting

    Started by raviraval86‎, 02-12-2022 04:52 PM
    index + match, offset formula, sumifs and and formula, sumproduct 4 Attachment(s)
    • 528
    Last Post: 02-17-2022 02:23 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] get frequency and ignor last 8 entires

    Started by Excl3454‎, 01-20-2022 01:08 AM
    frequency, most frequent value, offset formula, offset match 4 Attachment(s)
    • 293
    Last Post: 01-20-2022 11:56 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [SOLVED] average last 8 values of a columns as new numbers entering

    Started by Excl3454‎, 04-19-2021 03:38 PM
    average dynamic, offset column, offset formula 3 Attachment(s)
    • 462
    Last Post: 04-20-2021 06:13 PM
    by Excl3454  Go to last post

    Forum:
    Excel Formulas & Functions

  8. Find Cell in a Range that has same Month and Year as Referenced Cell

    Started by Stoogey7‎, 09-22-2020 09:38 PM
    for each cell, month & year match, month function, offset formula
    • 325
    Last Post: 09-24-2020 11:22 AM
    by maniacb  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  9. [SOLVED] Help with address, offset and sumif - get a value according other inputs with constraints

    Started by cgmstudnt‎, 01-10-2020 10:27 AM
    address array, difficult formula, finance, master formulas, offset formula 1 Attachment(s)
    • 599
    Last Post: 01-10-2020 11:46 AM
    by Pepe Le Mokko  Go to last post

    Forum:
    Excel General

  10. Searchable dropdown list using data validation, named ranges and Offset formula

    Started by timjo-b‎, 01-07-2020 07:57 AM
    cell contents formula, data validation list, drop down list, named range, offset formula, searchable dropdown list 10 Attachment(s)
    • 3,225
    Last Post: 02-22-2021 04:21 AM
    by MorgsKiWi  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Offset Problem

    Started by sskgintl‎, 01-03-2020 05:54 PM
    offset formula 1 Attachment(s)
    • 453
    Last Post: 01-10-2020 03:06 PM
    by sskgintl  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] Conditional Formatting with Offset Formula

    Started by sijostephen‎, 10-25-2019 01:29 AM
    advance excel, condition formatting, offset formula 3 Attachment(s)
    • 1,021
    Last Post: 10-25-2019 03:58 AM
    by sijostephen  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Autofill down a column using another sheet row data and skip one column each time

    Started by JohnPollardMDD‎, 04-14-2019 08:52 AM
    index array, offset formula
    • 393
    Last Post: 04-18-2019 07:57 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] Offset Troubles

    Started by Mclark8750‎, 03-18-2019 07:34 PM
    offset, offset formula, offset function, offset lines
    • 411
    Last Post: 03-19-2019 04:13 AM
    by rorya  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  15. OFFSET transposing error

    Started by 2deJulio‎, 12-07-2018 05:19 PM
    offset, offset formula, transpose column to row 1 Attachment(s)
    • 1,085
    Last Post: 12-07-2018 06:49 PM
    by XOR LX  Go to last post

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] Identify cell location from last cell in row with a value greater then 0

    Started by spyac‎, 10-30-2018 04:55 PM
    cell address, offset formula
    • 415
    Last Post: 11-01-2018 06:53 PM
    by spyac  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] I need help for formula instead of references

    Started by Navi_G‎, 06-09-2018 03:10 AM
    auto pick last day data, offset formula 1 Attachment(s)
    • 495
    Last Post: 06-09-2018 03:53 PM
    by Navi_G  Go to last post

    Forum:
    Excel General

  18. 12 month sum based on current date

    Started by lucas257‎, 04-20-2018 08:18 AM
    offset formula, sum across months 1 Attachment(s)
    • 514
    Last Post: 04-21-2018 04:04 AM
    by bebo021999  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Need formula(s) for Moving Totals to automatically update within that or another formula

    Started by DPKologie‎, 07-08-2017 10:31 PM
    match and index, moving totals, offset formula 1 Attachment(s)
    • 543
    Last Post: 07-15-2017 10:41 AM
    by Aardigspook  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] 12 month rolling chart

    Started by jdoerr1021‎, 06-28-2017 01:24 PM
    charts, offset formula, rolling 12 months 3 Attachment(s)
    • 5,456
    Last Post: 07-06-2017 05:48 PM
    by jdoerr1021  Go to last post

    Forum:
    Excel Charting & Pivots

  21. [SOLVED] Matching Data from multiple columns

    Started by jdoerr1021‎, 04-18-2017 11:13 AM
    matching data, offset formula 1 Attachment(s)
    • 497
    Last Post: 04-18-2017 11:33 AM
    by Special-K  Go to last post

    Forum:
    Excel General

  22. [SOLVED] OFFSET DV List stops working on each close and open of the workbook

    Started by BeachRock‎, 01-28-2017 12:02 AM
    data validation lists, offset formula 2 Attachment(s)
    • 944
    Last Post: 01-29-2017 01:04 PM
    by sandy666  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Dynamic Named Range doesn't return any values - help!

    Started by nickersonpower‎, 11-21-2016 11:56 AM
    data validation, dynamic named range, lists, name manager, offset formula
    • 4,896
    Last Post: 11-21-2016 01:01 PM
    by nickersonpower  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] How can I create dependent & dynamic DropDown lists that start with a certain string?

    Started by mcclausky‎, 09-17-2016 10:31 AM
    dependant lists, dropdown selection, offset formula 2 Attachment(s)
    • 755
    Last Post: 09-17-2016 01:44 PM
    by mcclausky  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Help defining range SUM and OFFSET together

    Started by dyoerdt‎, 02-24-2016 10:58 AM
    offset formula, sum and offset together 1 Attachment(s)
    • 687
    Last Post: 02-24-2016 12:52 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] How to stop sum(offset()) calculation at a particular column

    Started by carrach‎, 01-29-2016 08:44 AM
    end_at_column_position, excel_2010, offset formula 2 Attachment(s)
    • 4,486
    Last Post: 02-01-2016 04:49 AM
    by carrach  Go to last post

    Forum:
    Excel Formulas & Functions

  27. VLOOKUP with variable table array using INDIRECT and OFFSET

    Started by jbrizbee21‎, 08-11-2015 12:17 AM
    indirect function error, offset formula, table array, vlookup 2 Attachment(s)
    • 1,645
    Last Post: 08-11-2015 01:29 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Sum and conditional transpose of Excel table data

    Started by kc-s‎, 08-06-2015 09:07 AM
    offset, offset formula, sumif, transpose, transpose column to row 1 Attachment(s)
    • 1,760
    Last Post: 08-06-2015 11:39 AM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  29. Create formula to pull every 3rd cell from sheet1 to sheet2

    Started by rbexcel‎, 06-19-2015 08:55 AM
    offset formula, offset function
    • 724
    Last Post: 06-19-2015 09:33 AM
    by rbexcel  Go to last post

    Forum:
    Excel General

  30. Group each persons activities in a table with column ref

    Started by Cosima‎, 06-18-2015 05:23 AM
    formula, offset formula
    • 597
    Last Post: 06-19-2015 01:08 AM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Need Help: Remove blanks from a named range containing numerical values

    Started by AColonyOfAnts‎, 05-11-2015 03:39 PM
    name manager, offset formula 1 Attachment(s)
    • 889
    Last Post: 05-11-2015 03:54 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Dynamic Chart with an OFFSET that has a Dynamic reference gives error

    Started by Rifmaz‎, 04-10-2015 10:55 AM
    dynamic array formula, dynamic charts, offset formula
    • 1,219
    Last Post: 04-10-2015 11:53 AM
    by Rifmaz  Go to last post

    Forum:
    Excel Charting & Pivots

  33. [SOLVED] Offset or Index or both

    Started by richgoof‎, 02-06-2015 02:36 PM
    index, offset formula, offset function 2 Attachment(s)
    • 792
    Last Post: 02-06-2015 03:03 PM
    by AlKey  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Reference Cell as Sheet Name in Formula

    Started by johnctholen‎, 12-19-2014 12:55 PM
    offset formula, reference worksheets
    • 821
    Last Post: 12-19-2014 05:45 PM
    by martindwilson  Go to last post

    Forum:
    Excel Formulas & Functions

  35. Displaying furthest right value in row

    Started by bedwards11‎, 12-15-2014 05:28 AM
    count formula, data entry, offset formula, updating cells
    • 10,527
    Last Post: 12-15-2014 05:47 AM
    by bedwards11  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 41
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1