+ Post New Thread
Page 100 of 5604 FirstFirst ... 50 90 98 99 100 101 102 110 150 200 600 1100 ...
Threads 4951 to 5000 of 280186

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,757
    10-10-2007, 11:36 AM Go to last post
    • 14
    • 321
    07-16-2023, 04:21 AM Go to last post
    • 5
    • 270
    07-16-2023, 01:08 AM Go to last post
  1. Protect IF statement AND allow data entry

    Started by stilton‎, 07-05-2006 04:53 PM
    • 5
    • 984
    07-16-2023, 12:52 AM Go to last post
  2. [SOLVED] Binary search and return all matches as an array

    Started by revs92‎, 07-15-2023 10:17 AM
    array, binary search, lookup, xlookup
    • 5
    • 384
    07-15-2023, 09:10 PM Go to last post
  3. payments allocation to bills in fifo basis

    Started by harshit8999‎, 07-13-2023 02:04 AM
    • 6
    • 399
    07-15-2023, 01:58 PM Go to last post
    • 1
    • 120
    07-15-2023, 12:53 PM Go to last post
  4. Index Match Using MULTIPLE CRITERIA

    Started by jackoooooo‎, 07-15-2023 11:06 AM
    • 4
    • 291
    07-15-2023, 11:42 AM Go to last post
    • 4
    • 208
    07-15-2023, 11:39 AM Go to last post
  5. Drop down menu with totals

    Started by fgef‎, 07-14-2023 02:49 PM
    • 3
    • 248
    07-15-2023, 11:05 AM Go to last post
    • 4
    • 209
    07-15-2023, 10:30 AM Go to last post
  6. [SOLVED] Extract value from Range Column ignoring blank cells

    Started by d_shaun83‎, 07-15-2023 08:18 AM
    • 3
    • 337
    07-15-2023, 08:41 AM Go to last post
  7. [SOLVED] Display corresponding name for same number

    Started by kench‎, 09-15-2018 11:56 PM
    • 11
    • 1,816
    07-15-2023, 08:38 AM Go to last post
  8. [SOLVED] Sum If when using data with a timestamp

    Started by gemmac‎, 07-15-2023 06:20 AM
    • 6
    • 212
    07-15-2023, 08:21 AM Go to last post
  9. [SOLVED] conditional formatting that will color all cells with a formula

    Started by Pacho‎, 07-15-2023 05:17 AM
    • 4
    • 178
    07-15-2023, 07:51 AM Go to last post
  10. how to parametrise file name in VLOOKUP external link

    Started by Pacho‎, 07-13-2023 07:26 AM
    • 4
    • 291
    07-15-2023, 05:11 AM Go to last post
  11. Icon Sets

    Started by AJAX288‎, 07-14-2023 03:00 PM
    • 1
    • 211
    07-15-2023, 04:19 AM Go to last post
  12. [SOLVED] IFERROR(VLOOKUP()) with an IF(ISNA()) condition?

    Started by ckhan84‎, 07-13-2023 09:45 AM
    • 17
    • 531
    07-15-2023, 02:43 AM Go to last post
  13. Moved: Help calculate progress towards weight loss goal.

    Started by nkkhan‎, 07-14-2023 11:36 PM
    •  
    •  
    • 3
    • 261
    07-14-2023, 10:22 PM Go to last post
  14. [SOLVED] Finding most-often (frequency) works or gives REF error

    Started by akedm‎, 07-14-2023 03:42 AM
    • 6
    • 317
    07-14-2023, 09:09 PM Go to last post
  15. Combination of +IF formulas

    Started by Jonathan_Green‎, 07-14-2023 09:25 AM
    • 6
    • 296
    07-14-2023, 07:39 PM Go to last post
    • 5
    • 430
    07-14-2023, 05:46 PM Go to last post
    • 2
    • 253
    07-14-2023, 03:59 PM Go to last post
  16. Conditional Format the first x matching results?

    Started by abublitz‎, 07-14-2023 02:12 PM
    • 1
    • 179
    07-14-2023, 03:36 PM Go to last post
  17. [SOLVED] correct match in an area

    Started by fulldeen‎, 07-14-2023 12:02 PM
    • 3
    • 212
    07-14-2023, 03:03 PM Go to last post
  18. [SOLVED] Provide last user ignoring blanks except if only data

    Started by CatZ‎, 07-12-2023 12:16 PM
    • 7
    • 337
    07-14-2023, 12:12 PM Go to last post
  19. Forecast Model Removing Spikes

    Started by Lukas12345‎, 07-14-2023 10:53 AM
    • 6
    • 335
    07-14-2023, 11:55 AM Go to last post
    • 1
    • 137
    07-14-2023, 11:45 AM Go to last post
    • 4
    • 241
    07-14-2023, 10:30 AM Go to last post
    • 23
    • 378
    07-14-2023, 10:27 AM Go to last post
  20. [SOLVED] How do you password protect every other row by a specific COLOR?

    Started by cgotzeff‎, 07-05-2006 09:20 AM
    • 1
    • 549
    07-14-2023, 10:23 AM Go to last post
  21. [SOLVED] Parse text in cells for a column into a new column

    Started by Gregb11‎, 07-12-2023 11:35 AM
    • 11
    • 282
    07-14-2023, 09:31 AM Go to last post
  22. Question [SOLVED] Need help fixing formula to check if date is in current month.

    Started by EchoTwo‎, 07-13-2023 10:48 PM
    • 4
    • 213
    07-14-2023, 09:17 AM Go to last post
  23. Xlookup array formula problem

    Started by egoosen3‎, 07-14-2023 06:27 AM
    • 6
    • 382
    07-14-2023, 08:48 AM Go to last post
  24. Convert Date in mmm yyyy format

    Started by bhenlee‎, 07-14-2023 04:53 AM
    • 15
    • 437
    07-14-2023, 07:18 AM Go to last post
  25. Help with score predictor game

    Started by Uyster‎, 07-14-2023 04:17 AM
    • 9
    • 255
    07-14-2023, 06:04 AM Go to last post
  26. [SOLVED] How to modify table array when using vlookup

    Started by muharom.habib‎, 07-14-2023 05:23 AM
    • 2
    • 231
    07-14-2023, 05:46 AM Go to last post
  27. Report on potential duplicates

    Started by Livelife23‎, 07-14-2023 04:50 AM
    • 4
    • 228
    07-14-2023, 05:01 AM Go to last post
  28. Remove duplicated in TEXTJOIN formula

    Started by caamfin‎, 07-13-2023 01:57 AM
    • 10
    • 272
    07-14-2023, 03:01 AM Go to last post
  29. Find the closest numbers to a specific requirement.

    Started by virencm‎, 07-13-2023 10:57 PM
    • 6
    • 245
    07-14-2023, 02:02 AM Go to last post
  30. [SOLVED] Combining a custom data validation and a list validation

    Started by jmcole‎, 07-13-2023 01:18 PM
    • 3
    • 286
    07-13-2023, 05:29 PM Go to last post
  31. Calculation between two non sequential rows

    Started by jennyge‎, 07-10-2023 02:47 PM
    • 5
    • 337
    07-13-2023, 03:45 PM Go to last post
  32. [SOLVED] sumif but only if category contains values

    Started by PitchNinja‎, 07-13-2023 01:01 PM
    • 3
    • 211
    07-13-2023, 02:14 PM Go to last post
  33. [SOLVED] How to sum comparing two lists and return differences?

    Started by Manith‎, 07-12-2023 01:29 PM
    • 10
    • 333
    07-13-2023, 01:46 PM Go to last post
  34. Find sum combination

    Started by Geo Jul‎, 07-13-2023 10:51 AM
    • 7
    • 293
    07-13-2023, 12:22 PM Go to last post
  35. [SOLVED] Dynamic Range for Match Function

    Started by exilion‎, 07-13-2023 07:17 AM
    • 3
    • 303
    07-13-2023, 12:03 PM Go to last post
    • 2
    • 184
    07-13-2023, 10:49 AM Go to last post
    • 6
    • 271
    07-13-2023, 09:19 AM Go to last post
    • 7
    • 371
    07-13-2023, 08:44 AM Go to last post
    • 6
    • 280
    07-13-2023, 06:45 AM Go to last post

+ Post New Thread
Page 100 of 5604 FirstFirst ... 50 90 98 99 100 101 102 110 150 200 600 1100 ...

Forum Information and Options

Users Browsing this Forum

There are currently 131 users browsing this forum. (3 members & 128 guests)

  1. chri1977,
  2. Glenn Kennedy

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1