+ Post New Thread
Page 601 of 5612 FirstFirst ... 601 ...
Threads 30001 to 30050 of 280551

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

  1. [SOLVED] Allocation of amount between dates

    Started by haroonkhurshid‎, 10-28-2020 05:28 PM
    4 Attachment(s)
    • 8
    • 810
    JeteMc
    11-12-2020, 09:09 AM Go to last post

  2. [SOLVED] Use formulas to show visibility of employees

    Started by adamnc‎, 11-11-2020 11:57 AM
    3 Attachment(s)
    • 11
    • 344
    Squeaky
    11-12-2020, 09:03 AM Go to last post

  3. Converting a small amount of data into a row

    Started by Kalamari‎, 11-12-2020 08:32 AM
    2 Attachment(s)
    • 2
    • 190
    Kalamari
    11-12-2020, 08:46 AM Go to last post

  4. Post [SOLVED] Calculate cumulative sums and obtain highest value based on it

    Started by Rehman5000‎, 11-07-2020 01:40 AM
    aggregate, cumulative sum, lookup, maxifs minifs countifs, sumifs 9 Attachment(s)
    • 15
    • 1,802
    JeteMc
    11-12-2020, 08:43 AM Go to last post

  5. [SOLVED] Vacation half days to be counted and minused

    Started by riverman_27‎, 11-12-2020 06:44 AM
    2 Attachment(s)
    • 3
    • 204
    AliGW
    11-12-2020, 08:08 AM Go to last post

  6. Question can this be automated without VBA?

    Started by xlepws‎, 11-11-2020 05:36 AM
    • 5
    • 271
    kvsrinivasamurthy
    11-12-2020, 07:59 AM Go to last post

  7. Formula required for return a section wise different objects number of quantities.

    Started by Mohammad Munawar‎, 11-12-2020 04:39 AM
    lookup, multiple criteria, quantities. 4 Attachment(s)
    • 7
    • 558
    Mohammad Munawar
    11-12-2020, 07:43 AM Go to last post

  8. Formula help - Find date nearest to Monday

    Started by meegs‎, 11-11-2020 10:18 PM
    1 Attachment(s)
    • 14
    • 345
    kvsrinivasamurthy
    11-12-2020, 07:39 AM Go to last post

  9. [SOLVED] Conditional Formatting

    Started by brickaboodle‎, 11-12-2020 06:16 AM
    2 Attachment(s)
    • 2
    • 216
    AliGW
    11-12-2020, 07:17 AM Go to last post

  10. Finding latest date when column data is mixture of string and numbers

    Started by QSGuy‎, 11-09-2020 01:42 PM
    1 Attachment(s)
    • 12
    • 309
    QSGuy
    11-12-2020, 07:12 AM Go to last post

  11. [SOLVED] Need help removing a decimal from a cell

    Started by kgtrader‎, 11-11-2020 09:19 PM
    2 Attachment(s)
    • 3
    • 203
    kvsrinivasamurthy
    11-12-2020, 07:04 AM Go to last post

  12. How to calculate a shift cell depending on number of days

    Started by didierkassas‎, 11-11-2020 10:35 PM
    1 Attachment(s)
    • 3
    • 296
    Keebellah
    11-12-2020, 06:26 AM Go to last post

  13. [SOLVED] To show result the total count on specific character

    Started by SteveSJ‎, 11-12-2020 04:48 AM
    2 Attachment(s)
    • 4
    • 226
    Glenn Kennedy
    11-12-2020, 06:06 AM Go to last post

  14. [SOLVED] IF function formula

    Started by SteveSJ‎, 11-11-2020 01:01 AM
    2 Attachment(s)
    • 10
    • 307
    AliGW
    11-12-2020, 05:03 AM Go to last post

  15. [SOLVED] Assistant required on index & match formula

    Started by SteveSJ‎, 11-11-2020 11:13 PM
    2 Attachment(s)
    • 7
    • 401
    AliGW
    11-12-2020, 05:02 AM Go to last post

  16. [SOLVED] Monthly report using index match

    Started by sunboy‎, 11-11-2020 04:03 AM
    4 Attachment(s)
    • 18
    • 974
    Glenn Kennedy
    11-12-2020, 04:14 AM Go to last post

  17. [SOLVED] IF() system date not yet reached (compare with future date)

    Started by vba_php‎, 11-12-2020 01:55 AM
    • 6
    • 287
    AliGW
    11-12-2020, 03:57 AM Go to last post

  18. [SOLVED] Array Function - multiple criteria

    Started by boyspalm‎, 11-11-2020 05:07 PM
    array - multiple strings, array formula 1 Attachment(s)
    • 3
    • 451
    AliGW
    11-12-2020, 01:57 AM Go to last post

  19. Conditional Formatting to Highlight a cell Red when checkbox is UNCHECKED

    Started by clayshooter12‎, 11-11-2020 09:05 PM
    4 Attachment(s)
    • 5
    • 1,033
    bebo021999
    11-11-2020, 11:57 PM Go to last post

  20. CRAPS game spreadsheet. Need help with formulas!

    Started by BryantR‎, 11-03-2020 10:25 AM
    craps, craps game, dice, dice roll, random dice 7 Attachment(s)
    • 12
    • 1,251
    ChemistB
    11-11-2020, 07:10 PM Go to last post

  21. Need help analyzing matching/unmatching rows

    Started by EXPEDITION123‎, 11-11-2020 05:31 PM
    4 Attachment(s)
    • 11
    • 278
    Limor_OP
    11-11-2020, 06:58 PM Go to last post

  22. Any macro to autofill a series of rows based on given variables?

    Started by kehong216‎, 11-11-2020 04:27 PM
    1 Attachment(s)
    • 1
    • 162
    6StringJazzer
    11-11-2020, 06:14 PM Go to last post

  23. Exclamation [SOLVED] Column Selection based on dropdown

    Started by chandraganji‎, 11-11-2020 04:04 PM
    #dropdownlist 1 Attachment(s)
    • 2
    • 176
    chandraganji
    11-11-2020, 04:31 PM Go to last post

  24. [SOLVED] How to Show the Number of Days an Action is Overdue

    Started by AliMcG‎, 11-11-2020 10:52 AM
    1 Attachment(s)
    • 3
    • 364
    AliGW
    11-11-2020, 04:23 PM Go to last post

  25. [SOLVED] analyzing existing combinations

    Started by Essen‎, 11-02-2020 07:44 AM
    3 Attachment(s)
    • 7
    • 479
    JeteMc
    11-11-2020, 03:59 PM Go to last post

  26. How to color cells based on if that number is greater or less than another number years?

    Started by anoble1‎, 11-11-2020 03:26 PM
    • 1
    • 228
    Richard Buttrey
    11-11-2020, 03:44 PM Go to last post

  27. [SOLVED] sum combining data from more than one tables?

    Started by S@S‎, 11-11-2020 11:49 AM
    4 Attachment(s)
    • 6
    • 308
    S@S
    11-11-2020, 03:20 PM Go to last post

  28. [SOLVED] Help with Formula to remove decimals

    Started by kgtrader‎, 11-11-2020 02:01 PM
    3 Attachment(s)
    • 6
    • 293
    kgtrader
    11-11-2020, 02:52 PM Go to last post

  29. Excel formula

    Started by Alexgg‎, 11-11-2020 11:58 AM
    1 Attachment(s)
    • 7
    • 246
    alansidman
    11-11-2020, 02:28 PM Go to last post

  30. IF Statement & lookup to other columns - Job Application Spreadsheet

    Started by lexa-midnight‎, 11-03-2020 08:39 AM
    and_or, formula 3 Attachment(s)
    • 6
    • 340
    lexa-midnight
    11-11-2020, 01:49 PM Go to last post

  31. Question [SOLVED] Convert or split text to columns

    Started by costi_linho12‎, 11-11-2020 09:16 AM
    3 Attachment(s)
    • 5
    • 236
    costi_linho12
    11-11-2020, 01:46 PM Go to last post

  32. [SOLVED] Help Required for IF Formula (Current Points)

    Started by kgtrader‎, 11-10-2020 10:41 PM
    1 Attachment(s)
    • 2
    • 215
    kgtrader
    11-11-2020, 01:42 PM Go to last post

  33. [SOLVED] VLOOKUP with two conditions

    Started by Markulane‎, 11-11-2020 12:10 PM
    1 Attachment(s)
    • 3
    • 190
    Markulane
    11-11-2020, 12:49 PM Go to last post

  34. Post Want to Learn: Learning which employee takes photos for a specific task in a location

    Started by ImpressiveAce‎, 11-11-2020 11:40 AM
    1 Attachment(s)
    • 2
    • 168
    alansidman
    11-11-2020, 12:48 PM Go to last post

  35. [SOLVED] Stable Formula for Age from Id

    Started by sintek‎, 11-11-2020 11:56 AM
    • 6
    • 195
    sintek
    11-11-2020, 12:29 PM Go to last post

  36. IF() combined with MONTH() and YEAR() inside another IF() function

    Started by vba_php‎, 11-11-2020 03:54 AM
    5 Attachment(s)
    • 21
    • 335
    vba_php
    11-11-2020, 11:54 AM Go to last post

  37. = if > or 0 formula

    Started by jtglanton‎, 11-10-2020 06:12 PM
    • 3
    • 783
    Fluff13
    11-11-2020, 11:14 AM Go to last post

  38. [SOLVED] Formula to Remove Duplicates and Pull Unique Values into Desired Column

    Started by bjnockle‎, 11-10-2020 01:21 PM
    1 Attachment(s)
    • 7
    • 304
    Glenn Kennedy
    11-11-2020, 10:33 AM Go to last post

  39. [SOLVED] Aboslute reference Dragging formula help

    Started by Alexce101‎, 11-11-2020 09:56 AM
    1 Attachment(s)
    • 8
    • 336
    Fluff13
    11-11-2020, 10:28 AM Go to last post

  40. Red face [SOLVED] Comparing JSON data in two rows for every set of ID

    Started by chandramouliarun‎, 11-10-2020 07:23 AM
    comparison, json 2 Attachment(s)
    • 8
    • 824
    chandramouliarun
    11-11-2020, 10:08 AM Go to last post

  41. =IF Excel Formula that can use ranges

    Started by Overdahill‎, 11-11-2020 09:47 AM
    1 Attachment(s)
    • 3
    • 186
    AliGW
    11-11-2020, 10:00 AM Go to last post

  42. [SOLVED] Researching Formula

    Started by Naf_Fr‎, 10-22-2020 02:48 PM
    2 Attachment(s)
    • 5
    • 258
    Naf_Fr
    11-11-2020, 09:46 AM Go to last post

  43. [SOLVED] Lost in VLOOKUP, OFFSET, INDEX, etc...

    Started by JefferyK‎, 11-11-2020 07:17 AM
    index, offset, vlookup 3 Attachment(s)
    • 6
    • 389
    JefferyK
    11-11-2020, 09:36 AM Go to last post

  44. [SOLVED] Exclude range from randbetween

    Started by adamnc‎, 11-10-2020 03:41 PM
    4 Attachment(s)
    • 9
    • 2,612
    6StringJazzer
    11-11-2020, 08:56 AM Go to last post

  45. Extract Data Between "-"

    Started by Doug24‎, 11-11-2020 08:18 AM
    • 4
    • 203
    Glenn Kennedy
    11-11-2020, 08:44 AM Go to last post

  46. Search box for named ranges?

    Started by Nicolantonio‎, 11-11-2020 06:26 AM
    3 Attachment(s)
    • 4
    • 259
    torachan
    11-11-2020, 08:34 AM Go to last post

  47. Calculate Headcount by department, based on Hire date and Termination date

    Started by Cornelia‎, 11-22-2013 11:25 AM
    2 Attachment(s)
    • 10
    • 11,377
    cmetzker
    11-11-2020, 07:42 AM Go to last post

  48. [SOLVED] Create summary sheet

    Started by bkpraveen078‎, 11-11-2020 06:18 AM
    2 Attachment(s)
    • 3
    • 176
    bkpraveen078
    11-11-2020, 07:17 AM Go to last post

  49. Wink Subtraction Calculation w/requirement data is present

    Started by bdav1216‎, 11-07-2020 08:21 PM
    5 Attachment(s)
    • 13
    • 503
    Bo_Ry
    11-11-2020, 07:09 AM Go to last post

  50. [SOLVED] Match name to emails and move to sheet

    Started by leakingfuel‎, 11-11-2020 03:43 AM
    3 Attachment(s)
    • 7
    • 274
    AliGW
    11-11-2020, 06:33 AM Go to last post
+ Post New Thread
Page 601 of 5612 FirstFirst ... 601 ...

Forum Information and Options

Users Browsing this Forum

There are currently 57 users browsing this forum. (5 members & 52 guests)

  1. 6StringJazzer,
  2. alarryaaron,
  3. Boris Josipovic,
  4. Fred_111,
  5. JN831

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