+ Post New Thread
Page 104 of 5615 FirstFirst ... 104 ...
Threads 5151 to 5200 of 280710

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,909
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. Red face Headcount of People in Unit

    Started by excelhelp99‎, 07-30-2023 09:42 PM
    excel & array, excel formula, excel help formula 3 Attachment(s)
    • 5
    • 278
    windknife
    08-01-2023, 01:48 AM Go to last post

  2. Change Sheet Refernce incrementally in adjacent cells

    Started by Ralph_Australia‎, 07-29-2023 04:14 PM
    3 Attachment(s)
    • 13
    • 325
    AliGW
    08-01-2023, 12:47 AM Go to last post

  3. IF formula not populating correctly

    Started by rhino80‎, 08-01-2023 12:22 AM
    • 2
    • 130
    TMS
    08-01-2023, 12:40 AM Go to last post

  4. Dynamic Column for Index(Match(),Match()) Formula

    Started by fischelr01‎, 07-31-2023 01:53 PM
    4 Attachment(s)
    • 5
    • 206
    TMS
    07-31-2023, 08:00 PM Go to last post

  5. How to reference letters in a cell to formula

    Started by SAKVoith‎, 07-31-2023 04:29 PM
    1 Attachment(s)
    • 1
    • 165
    AliGW
    07-31-2023, 04:48 PM Go to last post

  6. Max value setting

    Started by Topg750‎, 07-31-2023 03:15 AM
    3 Attachment(s)
    • 18
    • 349
    Topg750
    07-31-2023, 03:33 PM Go to last post

  7. Average Formula but does not include blank fields

    Started by Travksallen2007‎, 07-31-2023 09:56 AM
    4 Attachment(s)
    • 9
    • 263
    MrShorty
    07-31-2023, 03:14 PM Go to last post

  8. [SOLVED] Formula used in Excel 2016 no longer working in Excel 365

    Started by mightymo77‎, 07-31-2023 11:00 AM
    • 4
    • 323
    mightymo77
    07-31-2023, 01:50 PM Go to last post

  9. Display Image Based on Excel Formula

    Started by mrichard‎, 07-13-2023 04:54 PM
    • 15
    • 683
    mrichard
    07-31-2023, 01:14 PM Go to last post

  10. [SOLVED] How do I change specific text color within a formula

    Started by thedunna‎, 07-31-2023 10:34 AM
    2 Attachment(s)
    • 7
    • 161
    Pete_UK
    07-31-2023, 12:15 PM Go to last post

  11. [SOLVED] How to separate a cell into individual cells

    Started by kyber‎, 07-31-2023 10:44 AM
    2 Attachment(s)
    • 8
    • 249
    Glenn Kennedy
    07-31-2023, 11:26 AM Go to last post

  12. Question Group first 5 column values and transpose them using functions and formulas

    Started by chuck_bort‎, 07-31-2023 08:50 AM
    formula, funchion, transpose column to row 2 Attachment(s)
    • 2
    • 222
    chuck_bort
    07-31-2023, 11:26 AM Go to last post

  13. Hourly Employee Head Count and Staffed Rooms

    Started by excelhelp99‎, 07-20-2023 02:32 PM
    excel & macro, excel advanced, excel advanced formula, excel formula 2 Attachment(s)
    • 8
    • 435
    JeteMc
    07-31-2023, 10:41 AM Go to last post

  14. [SOLVED] spill data over columns and rows with Byrow/lambda

    Started by Limor_OP‎, 07-31-2023 06:12 AM
    2 Attachment(s)
    • 13
    • 657
    AliGW
    07-31-2023, 10:18 AM Go to last post

  15. [SOLVED] Need advanced IndexMatch Formula with Specific Criteria for Obtaining Exact Desired Result

    Started by Pankaj jaswani‎, 07-31-2023 09:10 AM
    4 Attachment(s)
    • 3
    • 154
    Glenn Kennedy
    07-31-2023, 09:53 AM Go to last post

  16. When one cell changes, how do you show the difference in another cell

    Started by 88foxtrot‎, 07-31-2023 09:14 AM
    • 1
    • 131
    HansDouwe
    07-31-2023, 09:22 AM Go to last post

  17. [SOLVED] Sumfs Formula not giving correct Results

    Started by Howardc1001‎, 07-30-2023 11:34 PM
    2 Attachment(s)
    • 6
    • 211
    Howardc1001
    07-31-2023, 09:15 AM Go to last post

  18. Date Range by Person Shown another sheet by person in a Grid

    Started by rjmall0‎, 07-31-2023 07:59 AM
    4 Attachment(s)
    • 12
    • 184
    HansDouwe
    07-31-2023, 09:15 AM Go to last post

  19. [SOLVED] Concatenate and Sumif

    Started by ramesh27‎, 07-31-2023 02:10 AM
    2 Attachment(s)
    • 13
    • 252
    ramesh27
    07-31-2023, 08:46 AM Go to last post

  20. Barometric Formula for airplane performance calculation

    Started by logic203‎, 02-12-2018 08:30 PM
    2 Attachment(s)
    • 5
    • 1,019
    AliGW
    07-31-2023, 08:17 AM Go to last post

  21. Create a new table from rows from an existing data set based on a cell value

    Started by matt_hooks_79‎, 07-31-2023 06:52 AM
    2 Attachment(s)
    • 3
    • 166
    Glenn Kennedy
    07-31-2023, 07:29 AM Go to last post

  22. How to use multiple result data in dashboard sheet?

    Started by rizwanulhasan‎, 07-30-2023 04:55 AM
    controlbar 5 Attachment(s)
    • 5
    • 305
    rizwanulhasan
    07-31-2023, 07:19 AM Go to last post

  23. [SOLVED] need to get tabular data in excel based on the header reference

    Started by Sum‎, 07-31-2023 05:55 AM
    2 Attachment(s)
    • 5
    • 146
    AliGW
    07-31-2023, 06:20 AM Go to last post

  24. [SOLVED] Index Match not working

    Started by Mike952‎, 07-28-2023 08:15 AM
    4 Attachment(s)
    • 10
    • 340
    AliGW
    07-31-2023, 05:36 AM Go to last post

  25. [SOLVED] Calculating Dates?

    Started by watson150‎, 07-31-2023 12:25 AM
    1 Attachment(s)
    • 9
    • 190
    AliGW
    07-31-2023, 02:58 AM Go to last post

  26. [SOLVED] Add 1 if ranking different if same dont add

    Started by makinmomb‎, 07-30-2023 11:59 PM
    1 Attachment(s)
    • 6
    • 290
    AliGW
    07-31-2023, 02:05 AM Go to last post

  27. a multi-level dropdowns that parses data from a smart table

    Started by Gagarin-ace‎, 07-30-2023 03:00 AM
    2 Attachment(s)
    • 12
    • 279
    Gagarin-ace
    07-31-2023, 01:05 AM Go to last post

  28. [SOLVED] Get formula to get certain text from file name

    Started by rizmomin‎, 07-30-2023 12:08 AM
    1 Attachment(s)
    • 6
    • 204
    FDibbins
    07-30-2023, 10:59 PM Go to last post

  29. Creating an AutoPay Template

    Started by Dexter2‎, 07-29-2023 02:20 PM
    2 Attachment(s)
    • 3
    • 213
    JeteMc
    07-30-2023, 09:39 PM Go to last post

  30. IF Formula returning incorrect value

    Started by jsantos‎, 07-30-2023 02:14 PM
    2 Attachment(s)
    • 2
    • 173
    Pete_UK
    07-30-2023, 02:50 PM Go to last post

  31. Sum up number of hours in the format hh:mm:ss format

    Started by via135‎, 07-27-2023 01:02 PM
    3 Attachment(s)
    • 10
    • 329
    Czeslaw
    07-30-2023, 12:39 PM Go to last post

  32. [SOLVED] Excel formula to analyse production based on a days

    Started by sunboy‎, 07-30-2023 11:24 AM
    2 Attachment(s)
    • 3
    • 207
    AliGW
    07-30-2023, 12:09 PM Go to last post

  33. [SOLVED] User choice consolidation, with hierarchy applied result and then given a number

    Started by MikeTrainer‎, 07-30-2023 06:11 AM
    4 Attachment(s)
    • 10
    • 242
    Glenn Kennedy
    07-30-2023, 10:01 AM Go to last post

  34. Question Wanting to add numbers within a date

    Started by Ricardo0591‎, 07-28-2023 05:13 AM
    1 Attachment(s)
    • 12
    • 298
    FlameRetired
    07-30-2023, 09:46 AM Go to last post

  35. [SOLVED] Shorten formula using array approach

    Started by wilberforcep‎, 07-29-2023 09:51 AM
    array functions 3 Attachment(s)
    • 20
    • 400
    leelnich
    07-30-2023, 08:28 AM Go to last post

  36. Getpivotdata

    Started by michelle 1‎, 07-30-2023 04:12 AM
    • 1
    • 164
    AliGW
    07-30-2023, 08:17 AM Go to last post

  37. [SOLVED] Extract "Nth" word from text

    Started by rajeshn_in‎, 07-29-2023 10:08 PM
    1 Attachment(s)
    • 4
    • 179
    HansDouwe
    07-29-2023, 11:31 PM Go to last post

  38. [SOLVED] Splitting a cel to approx 255 signs but the last sign has to be a comma

    Started by Ed1971‎, 07-28-2023 08:47 AM
    1 Attachment(s)
    • 20
    • 239
    HansDouwe
    07-29-2023, 08:08 PM Go to last post

  39. [SOLVED] Vlookup with Row and Column values

    Started by rizmomin‎, 07-29-2023 03:35 PM
    4 Attachment(s)
    • 6
    • 201
    rizmomin
    07-29-2023, 07:48 PM Go to last post

  40. [SOLVED] Helps - join sheets by ID, but only maximum value

    Started by Csabs‎, 07-29-2023 04:29 PM
    joining sheets, look up function 1 Attachment(s)
    • 3
    • 163
    AliGW
    07-29-2023, 04:46 PM Go to last post

  41. Reverse engineer an IF statement

    Started by Statzz‎, 07-28-2023 05:18 PM
    2 Attachment(s)
    • 5
    • 275
    HansDouwe
    07-29-2023, 12:45 PM Go to last post

  42. Help:- Formula with dropdown list combobox

    Started by bindassladka‎, 07-27-2023 06:37 AM
    4 Attachment(s)
    • 8
    • 279
    GlennUK
    07-29-2023, 11:55 AM Go to last post

  43. [SOLVED] I want to group some items from a table I have created

    Started by Atwech‎, 06-03-2023 07:54 AM
    3 Attachment(s)
    • 20
    • 378
    Atwech
    07-29-2023, 11:16 AM Go to last post

  44. [SOLVED] Error in Formula

    Started by RUPESHRH‎, 07-29-2023 10:47 AM
    1 Attachment(s)
    • 2
    • 127
    Pete_UK
    07-29-2023, 10:54 AM Go to last post

  45. OFFICE 365 - Return last entered value based on multiple conditions

    Started by vitoaiaco‎, 07-29-2023 07:25 AM
    2 Attachment(s)
    • 6
    • 228
    AliGW
    07-29-2023, 10:30 AM Go to last post

  46. Combining rows by keyword

    Started by sosnowitz‎, 07-29-2023 05:53 AM
    2 Attachment(s)
    • 7
    • 198
    AliGW
    07-29-2023, 08:55 AM Go to last post

  47. Index and match not working

    Started by Ranbir‎, 07-28-2023 01:28 PM
    index and match 2 Attachment(s)
    • 8
    • 342
    AliGW
    07-29-2023, 08:31 AM Go to last post

  48. [SOLVED] Sum Automate Formula based on Dynamically Change Value

    Started by RUPESHRH‎, 07-29-2023 03:55 AM
    1 Attachment(s)
    • 6
    • 212
    HansDouwe
    07-29-2023, 07:56 AM Go to last post

  49. Identify unique rows with conditions

    Started by Still_Learning4‎, 07-29-2023 04:52 AM
    2 Attachment(s)
    • 4
    • 205
    Still_Learning4
    07-29-2023, 07:30 AM Go to last post

  50. [SOLVED] Divide And Sum An Array

    Started by JN831‎, 07-29-2023 12:30 AM
    2 Attachment(s)
    • 8
    • 207
    AliGW
    07-29-2023, 01:46 AM Go to last post
+ Post New Thread
Page 104 of 5615 FirstFirst ... 104 ...

Forum Information and Options

Users Browsing this Forum

There are currently 119 users browsing this forum. (5 members & 114 guests)

  1. bushwacked,
  2. goodboy,
  3. Phuocam,
  4. RaulSerg,
  5. viewotst

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