+ Post New Thread
Page 601 of 5613 FirstFirst ... 601 ...
Threads 30001 to 30050 of 280643

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. Date entered in a cell affects the date produced in other cells

    Started by BigMcBen‎, 11-16-2020 07:33 AM
    • 1
    • 164
    Pete_UK
    11-16-2020, 07:48 AM Go to last post

  2. Post [SOLVED] data rearrangement

    Started by usamampk‎, 11-15-2020 06:21 PM
    data 1 Attachment(s)
    • 7
    • 780
    Pete_UK
    11-16-2020, 05:46 AM Go to last post

  3. How to show the operand values of a formula as text in another cell

    Started by Hello BPeople‎, 11-13-2020 10:40 AM
    1 Attachment(s)
    • 6
    • 468
    Hello BPeople
    11-16-2020, 02:52 AM Go to last post

  4. [SOLVED] formula to find age group not working.

    Started by kv.singh‎, 11-16-2020 01:50 AM
    • 4
    • 353
    kv.singh
    11-16-2020, 02:49 AM Go to last post

  5. Debt repayment formula that includes future charges

    Started by AlexAgain‎, 11-14-2020 11:33 PM
    4 Attachment(s)
    • 14
    • 473
    AlexAgain
    11-16-2020, 12:04 AM Go to last post

  6. Post [SOLVED] data rearrangement in row

    Started by usamampk‎, 11-15-2020 09:10 PM
    data arrangement 3 Attachment(s)
    • 6
    • 425
    usamampk
    11-15-2020, 11:59 PM Go to last post

  7. [SOLVED] VLOOKUP avoiding rows with specific criteria

    Started by bowslam‎, 11-11-2020 10:29 PM
    2 Attachment(s)
    • 15
    • 574
    bowslam
    11-15-2020, 11:32 PM Go to last post

  8. Question [SOLVED] find numbers of films of each genre, and total expenses for each genre

    Started by joaoprv13‎, 11-15-2020 05:10 PM
    1 Attachment(s)
    • 1
    • 180
    Pete_UK
    11-15-2020, 05:23 PM Go to last post

  9. IF function

    Started by Natalija80‎, 11-08-2020 12:42 PM
    if function
    • 3
    • 525
    Natalija80
    11-15-2020, 05:05 PM Go to last post

  10. [SOLVED] Can the Sum Range of SumIf be stopped and only pick certain rows to sum?

    Started by jmbelly‎, 11-15-2020 03:34 PM
    2 Attachment(s)
    • 6
    • 325
    BMV
    11-15-2020, 04:27 PM Go to last post

  11. Question [SOLVED] insert different texts and show the respective results

    Started by joaoprv13‎, 11-15-2020 03:03 PM
    2 Attachment(s)
    • 3
    • 277
    Estevaoba
    11-15-2020, 03:59 PM Go to last post

  12. Changing a single point of data into a row of data merging identical items into total…

    Started by Kalamari‎, 11-12-2020 04:51 AM
    2 Attachment(s)
    • 1
    • 310
    JeteMc
    11-15-2020, 02:17 PM Go to last post

  13. Stacked IF statement

    Started by angelapefx‎, 11-14-2020 10:55 AM
    if statement formula, if statement help, if statements, nest if statement
    • 3
    • 366
    TMS
    11-15-2020, 01:42 PM Go to last post

  14. [SOLVED] SUMIFS - Between Dates & Times

    Started by Faustocruz‎, 11-15-2020 12:31 PM
    2 Attachment(s)
    • 2
    • 250
    Faustocruz
    11-15-2020, 01:17 PM Go to last post

  15. [SOLVED] Getting the average net sales based on the day

    Started by JeremyHaley‎, 11-14-2020 10:59 AM
    average 1 Attachment(s)
    • 3
    • 375
    AliGW
    11-15-2020, 12:43 PM Go to last post

  16. Exclamation [SOLVED] correspondence between 2 variables

    Started by joaoprv13‎, 11-15-2020 10:23 AM
    2 Attachment(s)
    • 9
    • 344
    AliGW
    11-15-2020, 12:38 PM Go to last post

  17. [SOLVED] Extract Data from a table and plot graph

    Started by jsridhar‎, 11-11-2020 01:17 PM
    3 Attachment(s)
    • 14
    • 592
    jsridhar
    11-15-2020, 12:24 PM Go to last post

  18. [SOLVED] Formula retrieving data from other worksheet when changing month _01,_02,_03 in a cell

    Started by megaheinz‎, 11-15-2020 07:26 AM
    2 Attachment(s)
    • 3
    • 225
    Glenn Kennedy
    11-15-2020, 08:39 AM Go to last post

  19. [SOLVED] 2 fields checker- Request for alternative option in Power Query or Power Pivot

    Started by Shareez Saleem‎, 11-15-2020 01:48 AM
    4 Attachment(s)
    • 5
    • 906
    Shareez Saleem
    11-15-2020, 08:36 AM Go to last post

  20. [SOLVED] Conditional Formating not working

    Started by AB4122‎, 11-11-2020 06:46 PM
    4 Attachment(s)
    • 12
    • 582
    AliGW
    11-15-2020, 07:07 AM Go to last post

  21. Returning a non-numerical value that matches another list

    Started by Peter Niklas‎, 11-15-2020 06:25 AM
    array, function, index, match 1 Attachment(s)
    • 2
    • 375
    Phuocam
    11-15-2020, 06:52 AM Go to last post

  22. Split Column View without sychronized scrolling

    Started by jsridhar‎, 11-14-2020 08:39 PM
    1 Attachment(s)
    • 1
    • 251
    AliGW
    11-15-2020, 05:23 AM Go to last post

  23. Formula to calculate average of most recent values

    Started by Jonny_71‎, 11-14-2020 06:10 PM
    • 5
    • 368
    FDibbins
    11-15-2020, 02:30 AM Go to last post

  24. ???is there a way to keep one row in view while scrolling down???

    Started by Jennie‎, 09-05-2005 10:05 PM
    • 1
    • 456
    jsridhar
    11-14-2020, 08:44 PM Go to last post

  25. Formula to work out the average value of the most recent entries

    Started by Jonny_71‎, 11-14-2020 01:34 PM
    1 Attachment(s)
    • 4
    • 310
    alansidman
    11-14-2020, 06:24 PM Go to last post

  26. Lightbulb [SOLVED] Greater Than Less Than in 5 Arguments in one cell.

    Started by Inz‎, 11-13-2020 02:45 PM
    1 Attachment(s)
    • 4
    • 312
    Aardigspook
    11-14-2020, 05:59 PM Go to last post

  27. Automatically load values out of 1 tab to another tab

    Started by kmh31872‎, 11-14-2020 02:23 PM
    1 Attachment(s)
    • 7
    • 254
    kmh31872
    11-14-2020, 05:07 PM Go to last post

  28. Function to count days since an incident

    Started by Stoopidfish‎, 11-14-2020 04:52 PM
    1 Attachment(s)
    • 1
    • 414
    maniacb
    11-14-2020, 05:07 PM Go to last post

  29. Matching lists with a function

    Started by Peter Niklas‎, 11-14-2020 01:25 PM
    function array, match, sumif + match 1 Attachment(s)
    • 8
    • 505
    Fluff13
    11-14-2020, 03:58 PM Go to last post

  30. [SOLVED] Converting data into a monthly calendar format/visual

    Started by Schaak‎, 11-11-2020 05:40 AM
    3 Attachment(s)
    • 9
    • 465
    Schaak
    11-14-2020, 02:46 PM Go to last post

  31. Need a formula\function that return first and last value within range of numbers

    Started by Davduv10‎, 11-13-2020 09:33 AM
    3 Attachment(s)
    • 7
    • 325
    Davduv10
    11-14-2020, 02:35 PM Go to last post

  32. Problem with IF and Or formula

    Started by hdh2014‎, 11-13-2020 11:47 PM
    • 4
    • 207
    alansidman
    11-14-2020, 01:51 PM Go to last post

  33. Redistribute / Rebalance Percentages

    Started by thunder2210‎, 11-14-2020 09:38 AM
    2 Attachment(s)
    • 5
    • 3,616
    thunder2210
    11-14-2020, 11:42 AM Go to last post

  34. Need Help creating formula to show when an amount has been met

    Started by slatergeneral‎, 11-14-2020 11:40 AM
    1 Attachment(s)
    • 1
    • 187
    Pepe Le Mokko
    11-14-2020, 11:40 AM Go to last post

  35. Help with notepad and excel

    Started by zerodock‎, 11-12-2020 04:58 PM
    • 2
    • 271
    zerodock
    11-14-2020, 08:16 AM Go to last post

  36. do not display result in a formula date

    Started by xam99‎, 11-14-2020 06:41 AM
    1 Attachment(s)
    • 4
    • 235
    AliGW
    11-14-2020, 07:30 AM Go to last post

  37. Moved: Google Sheets: remaining quantity formula???

    Started by denis_galenkov‎, 11-14-2020 06:10 AM
    •  
    •  

  38. In a summary sheet different ways sum up all values as per criteria from multiple sheets

    Started by Mohammad Munawar‎, 11-14-2020 02:05 AM
    criteria match, date, month, sum + indirect, values 4 Attachment(s)
    • 8
    • 674
    Glenn Kennedy
    11-14-2020, 05:38 AM Go to last post

  39. Find internatonal numbers

    Started by blblbl‎, 11-13-2020 09:03 AM
    1 Attachment(s)
    • 6
    • 355
    blblbl
    11-14-2020, 05:14 AM Go to last post

  40. Sum of Time and Time Total over 24 hours and over a series of dates

    Started by EWolfe‎, 11-13-2020 10:53 AM
    1 Attachment(s)
    • 6
    • 332
    Glenn Kennedy
    11-14-2020, 03:49 AM Go to last post

  41. Conditioning formatting does not apply to all cells

    Started by olga6542‎, 11-13-2020 11:59 AM
    1 Attachment(s)
    • 2
    • 261
    FDibbins
    11-14-2020, 01:57 AM Go to last post

  42. [SOLVED] Data Validation for interdependent cells in 3 columns

    Started by savetrees‎, 11-13-2020 08:14 AM
    1 Attachment(s)
    • 7
    • 291
    mehmetcik
    11-13-2020, 05:54 PM Go to last post

  43. Exclamation Merge multiple lists with blank rows

    Started by singhx3a‎, 08-15-2017 08:38 AM
    formula, functions, rows and columns 4 Attachment(s)
    • 7
    • 910
    Glenn Kennedy
    11-13-2020, 05:53 PM Go to last post

  44. [SOLVED] how to convert irregular day/time data into excel datetime.

    Started by jrtaylor‎, 11-12-2020 06:30 PM
    date & time calculation, date conversion 2 Attachment(s)
    • 14
    • 876
    hrlngrv
    11-13-2020, 05:15 PM Go to last post

  45. [SOLVED] Can SumIF be stopped after a unique value is recognized?

    Started by jmbelly‎, 11-10-2020 08:06 AM
    3 Attachment(s)
    • 6
    • 362
    JeteMc
    11-13-2020, 02:58 PM Go to last post

  46. Lightbulb Extract cell by reference to adjacent cell values

    Started by tgrogan8‎, 11-10-2020 05:16 PM
    2 Attachment(s)
    • 4
    • 341
    JeteMc
    11-13-2020, 02:48 PM Go to last post

  47. [SOLVED] SEARCH function not returning expected values?

    Started by cph020283‎, 11-10-2020 07:34 PM
    3 Attachment(s)
    • 14
    • 781
    cph020283
    11-13-2020, 02:45 PM Go to last post

  48. Hashtag # to spill a formula - excel 365

    Started by Limor_OP‎, 11-13-2020 12:54 PM
    2 Attachment(s)
    • 8
    • 1,965
    Fluff13
    11-13-2020, 02:22 PM Go to last post

  49. [SOLVED] Autofill non-sequential cell reference

    Started by outy565‎, 11-13-2020 01:00 PM
    2 Attachment(s)
    • 8
    • 1,121
    outy565
    11-13-2020, 02:14 PM Go to last post

  50. Transfer data based on Month

    Started by Wskip49‎, 10-17-2020 04:50 PM
    1 Attachment(s)
    • 7
    • 403
    Limor_OP
    11-13-2020, 02:03 PM Go to last post
+ Post New Thread
Page 601 of 5613 FirstFirst ... 601 ...

Forum Information and Options

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