+ Post New Thread
Page 103 of 5613 FirstFirst ... 103 ...
Threads 5101 to 5150 of 280642

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

  1. [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

  2. Barometric Formula for airplane performance calculation

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

  3. 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
    • 164
    Glenn Kennedy
    07-31-2023, 07:29 AM Go to last post

  4. 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

  5. [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

  6. [SOLVED] Index Match not working

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

  7. [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

  8. [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

  9. 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
    • 278
    Gagarin-ace
    07-31-2023, 01:05 AM Go to last post

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

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

  11. Creating an AutoPay Template

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

  12. 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

  13. 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

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

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

  15. [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

  16. 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

  17. [SOLVED] Shorten formula using array approach

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

  18. Getpivotdata

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

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

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

  20. [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

  21. [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

  22. [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

  23. 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

  24. 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

  25. [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
    • 377
    Atwech
    07-29-2023, 11:16 AM Go to last post

  26. [SOLVED] Error in Formula

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

  27. 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

  28. 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

  29. Index and match not working

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

  30. [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

  31. Identify unique rows with conditions

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

  32. [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

  33. Working Template Excel project navigation with Gantt Diagramm

    Started by miladin‎, 07-28-2023 07:10 AM
    gantt, gantt chart, gantt chart tracking 2 Attachment(s)
    • 1
    • 391
    menem
    07-29-2023, 12:19 AM Go to last post

  34. How to prevent strings with a hyphen from being converted to dates using a formula

    Started by anita2017‎, 07-17-2023 12:47 PM
    • 14
    • 494
    TMS
    07-29-2023, 12:09 AM Go to last post

  35. [SOLVED] Need a simple formula, IF today's date is August 1st MINUS 6 days, then return balance

    Started by thematrix05‎, 07-26-2023 03:46 PM
    2 Attachment(s)
    • 2
    • 219
    thematrix05
    07-28-2023, 05:51 PM Go to last post

  36. [SOLVED] Automate Sum Formula based on Range

    Started by RUPESHRH‎, 07-28-2023 11:18 AM
    1 Attachment(s)
    • 4
    • 172
    ExceLogan
    07-28-2023, 05:36 PM Go to last post

  37. Lightbulb get values from connected columns in excel based on multiple criteria

    Started by sanjuss2‎, 07-28-2023 07:52 AM
    3 Attachment(s)
    • 6
    • 304
    ExceLogan
    07-28-2023, 05:19 PM Go to last post

  38. [SOLVED] filter with excluding array

    Started by guillaume0314‎, 07-22-2023 05:49 AM
    3 Attachment(s)
    • 5
    • 210
    CARACALLA
    07-28-2023, 01:59 PM Go to last post

  39. [SOLVED] IF Function is not returning correct number for all cells

    Started by Zimmy242‎, 07-28-2023 10:43 AM
    1 Attachment(s)
    • 8
    • 187
    HansDouwe
    07-28-2023, 01:09 PM Go to last post

  40. Calculate Top 7 Team Points, and Sort by Scores

    Started by terrykalaka‎, 07-25-2023 10:00 PM
    1 Attachment(s)
    • 8
    • 292
    Fluff13
    07-28-2023, 11:53 AM Go to last post

  41. [SOLVED] index/match formula not working

    Started by ea223‎, 01-15-2013 12:55 PM
    index & match, match 1 Attachment(s)
    • 4
    • 726
    AliGW
    07-28-2023, 11:30 AM Go to last post

  42. Unhappy SUMIFS formula returns value 0

    Started by parthmaniar‎, 07-16-2023 07:20 AM
    countifs, sumifs and formula 3 Attachment(s)
    • 6
    • 357
    parthmaniar
    07-28-2023, 09:18 AM Go to last post

  43. How to add the correct number in column A.

    Started by joericons‎, 07-28-2023 03:45 AM
    1 Attachment(s)
    • 4
    • 188
    AliGW
    07-28-2023, 04:05 AM Go to last post

  44. [SOLVED] Index with Source Data on multiple sheets

    Started by phkc070408‎, 07-23-2023 10:28 AM
    5 Attachment(s)
    • 7
    • 332
    AliGW
    07-28-2023, 02:18 AM Go to last post

  45. [SOLVED] How to only display questions by a filter

    Started by Grant T‎, 07-27-2023 02:56 AM
    11 Attachment(s)
    • 28
    • 533
    AliGW
    07-28-2023, 02:16 AM Go to last post

  46. [SOLVED] Type in a cell and drop down filters list?

    Started by cell-dweller‎, 07-27-2023 10:18 PM
    • 6
    • 212
    AliGW
    07-28-2023, 02:14 AM Go to last post

  47. [SOLVED] Formula to pull the codes from a row to column when there is a value for the code

    Started by samyraj‎, 07-27-2023 03:41 PM
    2 Attachment(s)
    • 3
    • 171
    samyraj
    07-28-2023, 01:31 AM Go to last post

  48. [SOLVED] Serial Number formula with condition

    Started by nagesh.tvsr‎, 07-27-2023 11:46 PM
    2 Attachment(s)
    • 5
    • 259
    HansDouwe
    07-28-2023, 01:24 AM Go to last post

  49. Need Help with Average and If statement

    Started by PAguilar956‎, 07-27-2023 06:54 PM
    2 Attachment(s)
    • 6
    • 231
    AliGW
    07-28-2023, 01:06 AM Go to last post

  50. [SOLVED] Summarize data from source table with some conditions

    Started by kwilkwila‎, 07-27-2023 11:57 AM
    2 Attachment(s)
    • 4
    • 253
    kwilkwila
    07-28-2023, 12:08 AM Go to last post
+ Post New Thread
Page 103 of 5613 FirstFirst ... 103 ...

Forum Information and Options

Users Browsing this Forum

There are currently 77 users browsing this forum. (4 members & 73 guests)

  1. ExcelNewbie92,
  2. krishnapg,
  3. Narbar_123

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