+ Post New Thread
Page 411 of 5614 FirstFirst ... 411 ...
Threads 20501 to 20550 of 280690

Forum: Excel Formulas & Functions

Post and discuss Excel Formulas & functions.

  1. Thumbs up Sticky Thread Sticky: Excel Useful Links (see last post for new additions)

    Started by gopi_excel‎, 12-22-2006 08:14 PM
    • 19
    • 156,905
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. Import data from one folder to another

    Started by Tubtech‎, 10-21-2021 09:56 AM
    2 Attachment(s)
    • 0
    • 198
    Tubtech
    10-21-2021, 09:56 AM Go to last post

  2. Question [SOLVED] Partial text frequency counting in reports

    Started by losc‎, 10-21-2021 04:35 AM
    frequency, frequency text string, text analysis 5 Attachment(s)
    • 11
    • 472
    AliGW
    10-21-2021, 08:49 AM Go to last post

  3. [SOLVED] Need your help to solve =IF(ISNUMBER)

    Started by fly2waleed‎, 10-21-2021 08:02 AM
    1 Attachment(s)
    • 5
    • 273
    fly2waleed
    10-21-2021, 08:25 AM Go to last post

  4. Add a cell value to populate columns

    Started by Sionos‎, 10-21-2021 05:56 AM
    2 Attachment(s)
    • 4
    • 215
    Pete_UK
    10-21-2021, 06:54 AM Go to last post

  5. Find the index of substring in whole string in one cell

    Started by jaryszek‎, 10-18-2021 09:58 AM
    6 Attachment(s)
    • 15
    • 594
    AliGW
    10-21-2021, 06:16 AM Go to last post

  6. [SOLVED] convert Sumifs to sumproduct or similar

    Started by Stephen Reeves‎, 10-13-2021 06:27 AM
    subtotal conditional, sumproduct help 3 Attachment(s)
    • 13
    • 554
    Stephen Reeves
    10-21-2021, 06:15 AM Go to last post

  7. [SOLVED] Problem to reference a cell or range of cells in another worksheet in the same workbook

    Started by akalien‎, 10-20-2021 08:44 AM
    1 Attachment(s)
    • 7
    • 212
    AliGW
    10-21-2021, 05:22 AM Go to last post

  8. Combining Data based on common value

    Started by mohsin.bipu‎, 10-21-2021 04:22 AM
    3 Attachment(s)
    • 2
    • 201
    alansidman
    10-21-2021, 04:37 AM Go to last post

  9. Question Can't post even though my message contains ONLY a message (no links, images or video)

    Started by Adalom‎, 10-21-2021 03:32 AM
    2 Attachment(s)
    • 3
    • 239
    AliGW
    10-21-2021, 04:30 AM Go to last post

  10. [SOLVED] Formula for Countif Down Rows and Across Columns

    Started by dharvey1978‎, 10-20-2021 09:52 PM
    2 Attachment(s)
    • 1
    • 288
    davsth
    10-21-2021, 03:03 AM Go to last post

  11. [SOLVED] Lookup value then if value falls within date range

    Started by Todd_Mate‎, 10-20-2021 07:26 PM
    1 Attachment(s)
    • 3
    • 255
    AliGW
    10-21-2021, 02:29 AM Go to last post

  12. Needing Help with Matching

    Started by ctuck1002‎, 10-17-2021 12:22 PM
    3 Attachment(s)
    • 7
    • 409
    JeteMc
    10-20-2021, 09:56 PM Go to last post

  13. how to lock rows of info when filtering

    Started by ginhc‎, 10-20-2021 09:02 PM
    • 0
    • 233
    ginhc
    10-20-2021, 09:02 PM Go to last post

  14. Combining Lookup and Match (I think) formula

    Started by mojennifer‎, 10-20-2021 03:26 PM
    1 Attachment(s)
    • 3
    • 230
    mojennifer
    10-20-2021, 07:09 PM Go to last post

  15. [SOLVED] Extract specific number of characters if word in cell begins with specific text

    Started by Tapyr‎, 10-20-2021 06:04 PM
    2 Attachment(s)
    • 3
    • 341
    alansidman
    10-20-2021, 06:29 PM Go to last post

  16. [SOLVED] Need Help with time conversion

    Started by bison41187‎, 10-20-2021 05:43 PM
    • 3
    • 180
    AliGW
    10-20-2021, 06:03 PM Go to last post

  17. AVERAGEIFS with condition NOT to include cells with letter

    Started by Doreen N‎, 10-20-2021 02:43 PM
    averageifs, exclude cells 1 Attachment(s)
    • 2
    • 933
    Pete_UK
    10-20-2021, 05:58 PM Go to last post

  18. Post Picking Maximum Value Given Constraints without Duplicates

    Started by jacquedd‎, 10-20-2021 04:22 PM
    duplicates, fantasy, max, maxifs, unique
    • 2
    • 457
    RaulSerg
    10-20-2021, 04:36 PM Go to last post

  19. Check if multiple criteria are met in lines above

    Started by pvp‎, 10-20-2021 03:29 PM
    1 Attachment(s)
    • 1
    • 200
    protonLeah
    10-20-2021, 04:24 PM Go to last post

  20. Need help with an arrayformula that repeats a list in a particular way.

    Started by holysheet‎, 10-15-2021 08:40 PM
    arrayformula, automate, list, repeat 5 Attachment(s)
    • 1
    • 457
    JeteMc
    10-20-2021, 03:52 PM Go to last post

  21. [SOLVED] Finding the next available lowest number in a sequence

    Started by cjcreamer‎, 10-20-2021 02:56 PM
    1 Attachment(s)
    • 3
    • 320
    Fluff13
    10-20-2021, 03:03 PM Go to last post

  22. [SOLVED] Vacation Pro-ration Formulas to encompass Leave time off

    Started by PitchNinja‎, 10-19-2021 02:05 PM
    1 Attachment(s)
    • 4
    • 241
    PitchNinja
    10-20-2021, 03:02 PM Go to last post

  23. [SOLVED] Separating Unique values

    Started by Stevenbossche‎, 10-19-2021 02:16 PM
    4 Attachment(s)
    • 4
    • 305
    Stevenbossche
    10-20-2021, 02:54 PM Go to last post

  24. [SOLVED] Power Query transformation of unrecognizable date/time format in column with various input

    Started by Marbleking‎, 10-20-2021 05:44 AM
    date/time, power query, transform 3 Attachment(s)
    • 6
    • 385
    Marbleking
    10-20-2021, 02:15 PM Go to last post

  25. Use popup to select which columns to sum

    Started by digitdemon‎, 10-20-2021 01:15 PM
    1 Attachment(s)
    • 1
    • 194
    JohnTopley
    10-20-2021, 01:40 PM Go to last post

  26. [SOLVED] Formula for nested lookup, to verify if date is within range for given row

    Started by a1mty‎, 10-19-2021 02:32 PM
    1 Attachment(s)
    • 3
    • 228
    GeoffW283
    10-20-2021, 01:33 PM Go to last post

  27. index match horizontal and vertical array

    Started by sonu1975‎, 10-20-2021 11:05 AM
    1 Attachment(s)
    • 16
    • 398
    Fluff13
    10-20-2021, 01:31 PM Go to last post

  28. average daily in a daily column

    Started by Nixon1‎, 10-20-2021 12:46 PM
    • 1
    • 203
    JohnTopley
    10-20-2021, 01:25 PM Go to last post

  29. [SOLVED] Problem with nested IF formula

    Started by bpigott‎, 10-19-2021 07:55 PM
    2 Attachment(s)
    • 4
    • 289
    FlameRetired
    10-20-2021, 12:36 PM Go to last post

  30. [SOLVED] Calculate TRIMMEAN with multiple conditions

    Started by cableghost‎, 10-14-2021 10:58 AM
    conditions, formula 1 Attachment(s)
    • 6
    • 802
    cableghost
    10-20-2021, 12:07 PM Go to last post

  31. Exclamation [SOLVED] make a Ranking list for my comic book collection

    Started by SootySkunk‎, 10-20-2021 11:37 AM
    formula, listing, lookup, search 1 Attachment(s)
    • 2
    • 326
    SootySkunk
    10-20-2021, 11:50 AM Go to last post

  32. [SOLVED] How to change change formulas such that formula is based on Work Days rather than Days

    Started by Holan95‎, 10-19-2021 04:25 PM
    2 Attachment(s)
    • 4
    • 230
    Holan95
    10-20-2021, 11:40 AM Go to last post

  33. [SOLVED] Finding the second lowest value

    Started by parbynat‎, 10-20-2021 11:00 AM
    1 Attachment(s)
    • 5
    • 294
    wk9128
    10-20-2021, 11:32 AM Go to last post

  34. Question [SOLVED] Reorganise Cells according to an ID

    Started by faoiltiama‎, 10-20-2021 07:49 AM
    2 Attachment(s)
    • 2
    • 296
    faoiltiama
    10-20-2021, 10:49 AM Go to last post

  35. [SOLVED] How to take the highest score of repeated data?

    Started by choletseng‎, 10-19-2021 11:20 AM
    2 Attachment(s)
    • 8
    • 246
    wk9128
    10-20-2021, 10:45 AM Go to last post

  36. [SOLVED] Unsupported Formula on Mac for one user but not others

    Started by kyle4570‎, 10-20-2021 09:50 AM
    • 3
    • 179
    TMS
    10-20-2021, 10:17 AM Go to last post

  37. How to get multiple values from Vlookup

    Started by mwburne‎, 10-19-2021 08:59 PM
    2 Attachment(s)
    • 8
    • 313
    alansidman
    10-20-2021, 10:08 AM Go to last post

  38. How to connect units in series

    Started by choletseng‎, 10-20-2021 08:09 AM
    2 Attachment(s)
    • 2
    • 211
    choletseng
    10-20-2021, 08:28 AM Go to last post

  39. [SOLVED] Copy cells with values

    Started by hkaric‎, 10-20-2021 05:50 AM
    2 Attachment(s)
    • 6
    • 210
    AliGW
    10-20-2021, 07:29 AM Go to last post

  40. listing the 2, 598, 960 different poker hands in separate cells

    Started by Chico‎, 11-11-2007 02:02 AM
    • 19
    • 7,982
    NDK
    10-20-2021, 07:15 AM Go to last post

  41. Exclamation [SOLVED] Conditional formatting with formulas

    Started by YSFG‎, 10-13-2021 11:43 AM
    1 Attachment(s)
    • 6
    • 256
    YSFG
    10-20-2021, 06:39 AM Go to last post

  42. Reshaping a matrix with formulas

    Started by RaulSerg‎, 10-18-2021 10:51 AM
    5 Attachment(s)
    • 11
    • 396
    RaulSerg
    10-20-2021, 05:53 AM Go to last post

  43. [SOLVED] Check for duplicates horizontally in Excel

    Started by julian.wee‎, 05-24-2018 01:17 AM
    3 Attachment(s)
    • 11
    • 6,991
    AliGW
    10-20-2021, 05:39 AM Go to last post

  44. [SOLVED] How to sum data between two dates by project type

    Started by hmattoo98‎, 10-20-2021 04:34 AM
    4 Attachment(s)
    • 15
    • 325
    JohnTopley
    10-20-2021, 05:34 AM Go to last post

  45. IF(IF(IF... more than 64 nesting level

    Started by NoJi‎, 10-19-2021 08:19 AM
    if(if(if... 4 Attachment(s)
    • 10
    • 406
    RaulSerg
    10-20-2021, 05:12 AM Go to last post

  46. [SOLVED] Averageifs exclude zero from

    Started by hkaric‎, 10-20-2021 03:41 AM
    1 Attachment(s)
    • 3
    • 310
    wk9128
    10-20-2021, 05:04 AM Go to last post

  47. Amortization table for line of credit with incremental loan amounts, variable int rates

    Started by jonathanwsmith‎, 10-06-2021 05:34 PM
    1 Attachment(s)
    • 3
    • 287
    davsth
    10-20-2021, 03:14 AM Go to last post

  48. [SOLVED] Count continuous instances and get max value from corresponding column

    Started by Nostradamus‎, 10-06-2021 09:35 PM
    if then criteria range 6 Attachment(s)
    • 38
    • 906
    davsth
    10-20-2021, 03:00 AM Go to last post

  49. [SOLVED] Cell contains a date then returns a certain text

    Started by emmagizer‎, 09-27-2021 02:29 AM
    4 Attachment(s)
    • 18
    • 658
    AliGW
    10-20-2021, 02:52 AM Go to last post

  50. [SOLVED] Formula to find the most recent value in a range of cells and return financial year name

    Started by Nago‎, 10-19-2021 11:31 AM
    1 Attachment(s)
    • 6
    • 249
    AliGW
    10-20-2021, 02:50 AM Go to last post
+ Post New Thread
Page 411 of 5614 FirstFirst ... 411 ...

Forum Information and Options

Users Browsing this Forum

There are currently 53 users browsing this forum. (4 members & 49 guests)

  1. AliGW,
  2. CARACALLA,
  3. etaf,
  4. TMS

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1