Search:

Tag: offset

Page 1 of 16 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. [SOLVED] Why I cannot switch formulas in a complex formula?

    Started by Delta_Fox‎, 04-06-2024 05:25 AM
    error, large, offset 1 Attachment(s)
    • 102
    Last Post: 04-06-2024 06:49 AM
    by josephteh  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Dynamic named range and indirect function

    Started by m4rkybob‎, 12-21-2023 01:50 PM
    dynamic named range, index, offset
    • 172
    Last Post: 12-21-2023 02:19 PM
    by deadlyduck  Go to last post

    Forum:
    Excel General

  3. Displaying the last 6 values in a row

    Started by Big Gee‎, 06-29-2023 10:54 AM
    defined name, index & match, offset 1 Attachment(s)
    • 302
    Last Post: 06-29-2023 11:14 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Small If Offset ?

    Started by 77highland‎, 06-02-2023 05:59 PM
    offset, smallif 1 Attachment(s)
    • 203
    Last Post: 06-02-2023 06:35 PM
    by 77highland  Go to last post

    Forum:
    Excel Formulas & Functions

  5. Complicated row and column lookup

    Started by danibitter75‎, 05-23-2023 08:42 AM
    columns, lookup, offset 5 Attachment(s)
    • 649
    Last Post: 05-24-2023 09:20 AM
    by John Vergara  Go to last post

    Forum:
    Excel General

  6. Converting 10 minute interval data into hourly average

    Started by laka9‎, 03-14-2023 07:00 AM
    houry, offset 2 Attachment(s)
    • 392
    Last Post: 03-14-2023 10:13 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  7. [SOLVED] Small issue function offset

    Started by alexsantos1990‎, 02-10-2023 07:31 AM
    offset 4 Attachment(s)
    • 287
    Last Post: 02-11-2023 02:54 AM
    by alexsantos1990  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] Extract Data From Rows Above With Formula

    Started by eNinjaInTraining‎, 02-09-2023 02:14 PM
    extract, formula, offset 1 Attachment(s)
    • 258
    Last Post: 02-10-2023 03:46 PM
    by eNinjaInTraining  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Creating a rolling average by using offset?

    Started by Chon1978‎, 02-08-2023 10:50 PM
    forecasting, offset 5 Attachment(s)
    • 461
    Last Post: 02-09-2023 11:07 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] Finding date in which the average for trailing 6 months is >= x

    Started by Robertcm99‎, 02-08-2023 08:11 PM
    averageifs, different range sizes, minifs, offset 4 Attachment(s)
    • 414
    Last Post: 02-10-2023 09:06 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] How to improve time on copying last row n times below data + leave last row as formula

    Started by laura.gomper‎, 02-06-2023 01:17 PM
    copy rows, offset, paste by value
    • 293
    Last Post: 02-08-2023 08:43 AM
    by laura.gomper  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  12. [SOLVED] Dynamic Range in For Loop

    Started by phbryan‎, 11-16-2022 05:06 PM
    find, for loop, offset 1 Attachment(s)
    • 262
    Last Post: 11-17-2022 03:35 AM
    by BadlySpelledBuoy  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  13. [SOLVED] Dependent validation list

    Started by Andy C.‎, 11-10-2022 09:23 AM
    index + match, offset, validated list 1 Attachment(s)
    • 366
    Last Post: 11-11-2022 12:33 PM
    by Estevaoba  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Looking for the correct formula to retrieve the data (forgot to use sample last time)

    Started by ily4everrrrr‎, 11-10-2022 09:16 AM
    indirect, offset, sum, xlookup 1 Attachment(s)
    • 292
    Last Post: 11-10-2022 09:23 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Looking for the correct formula to retrieve the data

    Started by ily4everrrrr‎, 11-10-2022 08:26 AM
    indirect, offset, row, xlookup 10 Attachment(s)
    • 504
    Last Post: 11-11-2022 07:13 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  16. FORECAST function to interpolate using index match given blank cells

    Started by cbeveridge‎, 11-08-2022 08:59 PM
    dynamic calculation, forecast function, index + match, interpolate, offset 1 Attachment(s)
    • 942
    Last Post: 11-10-2022 12:08 AM
    by MrShorty  Go to last post

    Forum:
    Excel General

  17. want to get amounts by month from a cohorted data

    Started by geneticsmeister‎, 11-06-2022 02:41 PM
    excel, excel & array, indirect & match, offset 3 Attachment(s)
    • 501
    Last Post: 11-09-2022 01:32 PM
    by 52779  Go to last post

    Forum:
    Excel Formulas & Functions

  18. Table Size based on cell Value

    Started by Kevin Rush‎, 09-29-2022 09:33 AM
    offset, tables 2 Attachment(s)
    • 686
    Last Post: 09-29-2022 10:53 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  19. [SOLVED] Spillable Function across multiple Dynamic Columns

    Started by ExcelPandit‎, 09-26-2022 07:51 PM
    dynamic arrays, index, offset, spillable array 2 Attachment(s)
    • 349
    Last Post: 09-28-2022 08:08 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] Lookup first n number of results from filtered table to another sheet

    Started by FetchOpt‎, 09-02-2022 02:17 PM
    filter, index + match, offset 1 Attachment(s)
    • 347
    Last Post: 09-03-2022 12:48 AM
    by Eastw00d  Go to last post

    Forum:
    Excel Formulas & Functions

  21. Cross Country Tie Breaking Formula

    Started by rjj920‎, 06-15-2022 11:02 AM
    cross country, less than and equal to, match, offset, sports 2 Attachment(s)
    • 493
    Last Post: 06-16-2022 03:47 AM
    by nick.williams  Go to last post

    Forum:
    Excel Formulas & Functions

  22. Lagged value based on groups and date

    Started by oxlade‎, 06-14-2022 03:10 AM
    lag, lagging, offset 2 Attachment(s)
    • 433
    Last Post: 06-16-2022 09:45 AM
    by oxlade  Go to last post

    Forum:
    Excel General

  23. Don't know how to get cell value depending on date.

    Started by XCLNOOOB‎, 06-05-2022 02:18 PM
    date, match, offset 2 Attachment(s)
    • 344
    Last Post: 06-05-2022 05:23 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel General

  24. Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

    Started by chefanator‎, 05-30-2022 08:33 AM
    match, offset, sumproduct 3 Attachment(s)
    • 635
    Last Post: 05-31-2022 07:49 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Max Moving Average Formula REVISON

    Started by Flyboy1969‎, 05-09-2022 02:11 AM
    max, moving average, offset, subtotal 3 Attachment(s)
    • 429
    Last Post: 05-10-2022 11:35 AM
    by Flyboy1969  Go to last post

    Forum:
    Excel Formulas & Functions

  26. XIRR function with relative references

    Started by exceltrainee314‎, 05-05-2022 11:51 PM
    address, cell, irr, offset, relative references 1 Attachment(s)
    • 430
    Last Post: 05-09-2022 08:49 AM
    by exceltrainee314  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] Offset malfunction in Excel 2019

    Started by Zarathrustra‎, 04-24-2022 12:37 PM
    average, links, offset 2 Attachment(s)
    • 1,052
    Last Post: 05-08-2022 09:16 AM
    by Zarathrustra  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Help with Loop

    Started by evanders12‎, 03-31-2022 12:24 AM
    loop, offset 2 Attachment(s)
    • 312
    Last Post: 03-31-2022 10:08 AM
    by 6StringJazzer  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  29. [SOLVED] Offset reference to a button

    Started by KerahJoy‎, 03-30-2022 01:26 PM
    button, offset, vba
    • 377
    Last Post: 03-30-2022 05:48 PM
    by Artik  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  30. [SOLVED] Dynamic SUMIFS range (Dynamic OFFSET)

    Started by iop‎, 03-03-2022 04:49 AM
    dynamic offset, offset, sumifs 2 Attachment(s)
    • 752
    Last Post: 03-03-2022 05:56 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Replacing OFFSET to sum up to max value from specific cell

    Started by mfeengineer‎, 02-25-2022 01:59 PM
    max, offset, offset alternative, subtotal, sum 6 Attachment(s)
    • 642
    Last Post: 02-26-2022 09:58 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  32. How to choose an offset function starting point/reference

    Started by donman2318‎, 02-23-2022 10:58 PM
    offset, reference, reference argument, starting, starting point
    • 462
    Last Post: 02-25-2022 09:02 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  33. [SOLVED] Lookup Results Are Coming Up Offset???

    Started by cpalmer72‎, 02-17-2022 10:27 AM
    formula, lookup, offset, results 2 Attachment(s)
    • 518
    Last Post: 02-18-2022 12:39 PM
    by cpalmer72  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] Sumproduct produces #VALUE! if Row() is included in Offset funtion

    Started by wisemaj‎, 02-06-2022 12:11 AM
    #value! error, offset, row(), sumproduct 1 Attachment(s)
    • 651
    Last Post: 02-07-2022 12:33 AM
    by wisemaj  Go to last post

    Forum:
    Excel Formulas & Functions

  35. [SOLVED] Value of every nth row in a column

    Started by jrtaylor‎, 01-13-2022 02:41 PM
    every nth row, offset 2 Attachment(s)
    • 680
    Last Post: 01-13-2022 08:33 PM
    by wk9128  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 528
Page 1 of 16 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1