+ Post New Thread
Page 511 of 5614 FirstFirst ... 511 ...
Threads 25501 to 25550 of 280655

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

  1. [SOLVED] Worksheet name using =cell... formula

    Started by sonu1975‎, 04-14-2021 07:18 AM
    1 Attachment(s)
    • 3
    • 217
    samba_ravi
    04-14-2021, 07:45 AM Go to last post

  2. [SOLVED] Rotation shift

    Started by locos‎, 04-14-2021 05:39 AM
    1 Attachment(s)
    • 2
    • 437
    locos
    04-14-2021, 07:36 AM Go to last post

  3. [SOLVED] Network Days spread through months

    Started by g.costapinto‎, 04-14-2021 05:31 AM
    multi-layered formula, network days 2 Attachment(s)
    • 7
    • 392
    g.costapinto
    04-14-2021, 07:27 AM Go to last post

  4. [SOLVED] Return blank if range is blank

    Started by vill‎, 04-14-2021 07:00 AM
    blank 2 Attachment(s)
    • 3
    • 314
    vill
    04-14-2021, 07:17 AM Go to last post

  5. Pivottable, change font-colour based on value from a different cell

    Started by Drayne‎, 04-14-2021 06:20 AM
    @excel, @pivottable
    • 0
    • 288
    Drayne
    04-14-2021, 06:20 AM Go to last post

  6. [SOLVED] Building a list with multiple checkboxes

    Started by joerguk‎, 04-01-2021 11:16 AM
    5 Attachment(s)
    • 17
    • 543
    joerguk
    04-14-2021, 05:24 AM Go to last post

  7. Question [SOLVED] If Cell says "Y", xref with cell to left AND 5th cell to right

    Started by gameoverman‎, 04-13-2021 08:48 PM
    lookup match columns if
    • 7
    • 310
    AliGW
    04-14-2021, 05:20 AM Go to last post

  8. need to incorporate team players Name based on down wise from one sheet to next sheet

    Started by Suresh K R‎, 04-14-2021 04:38 AM
    1 Attachment(s)
    • 4
    • 199
    AliGW
    04-14-2021, 05:10 AM Go to last post

  9. Moved: Comparing data between two workbooks and highlighting any changes

    Started by Disco2000!‎, 04-14-2021 04:48 AM
    •  
    •  

  10. [SOLVED] how to sum data using 2 criteria

    Started by DimitrisPap‎, 04-12-2021 05:08 AM
    2 Attachment(s)
    • 13
    • 377
    AliGW
    04-14-2021, 04:46 AM Go to last post

  11. [SOLVED] INDEX/MATCH formula to extract specific data from table

    Started by MusiuPublic‎, 04-14-2021 03:55 AM
    2 Attachment(s)
    • 8
    • 268
    AliGW
    04-14-2021, 04:34 AM Go to last post

  12. [SOLVED] Workday formula

    Started by lia86‎, 04-13-2021 09:57 PM
    2 Attachment(s)
    • 5
    • 393
    AliGW
    04-14-2021, 04:14 AM Go to last post

  13. Multiple Returns forumla.

    Started by garymac93‎, 04-14-2021 03:07 AM
    formula support 2 Attachment(s)
    • 3
    • 242
    Glenn Kennedy
    04-14-2021, 03:32 AM Go to last post

  14. [SOLVED] nth non blank cell value smaller than

    Started by Excl3454‎, 04-13-2021 06:51 PM
    3 Attachment(s)
    • 2
    • 258
    Bo_Ry
    04-14-2021, 03:32 AM Go to last post

  15. Counting over any time period

    Started by Taz0705‎, 04-12-2021 09:46 AM
    3 Attachment(s)
    • 4
    • 337
    bebo021999
    04-14-2021, 03:09 AM Go to last post

  16. Change the text font

    Started by karka‎, 03-12-2021 08:30 AM
    4 Attachment(s)
    • 4
    • 361
    karka
    04-14-2021, 02:06 AM Go to last post

  17. Question SUMPRODUCT alternative for 2D spilled range formula

    Started by leolapa‎, 04-14-2021 01:49 AM
    1 Attachment(s)
    • 0
    • 330
    leolapa
    04-14-2021, 01:49 AM Go to last post

  18. [SOLVED] nth non blank cell value smaller than

    Started by Excl3454‎, 04-13-2021 08:36 PM
    formuala, non blank cell value, nth value 2 Attachment(s)
    • 2
    • 407
    Excl3454
    04-14-2021, 12:47 AM Go to last post

  19. How to automatically show value from a table (row) every time a new entry is made

    Started by sniper1‎, 04-13-2021 07:00 PM
    2 Attachment(s)
    • 1
    • 235
    kvsrinivasamurthy
    04-14-2021, 12:03 AM Go to last post

  20. [SOLVED] Countifs returning #SPILL or #VALUE error

    Started by Brapp2Smokin‎, 04-12-2021 05:01 PM
    2 Attachment(s)
    • 7
    • 1,884
    Gregb11
    04-13-2021, 10:25 PM Go to last post

  21. [SOLVED] moving letters from the middle of digits

    Started by Chanty‎, 04-12-2021 03:41 AM
    3 Attachment(s)
    • 17
    • 484
    bebo021999
    04-13-2021, 10:10 PM Go to last post

  22. [SOLVED] Calculating % Progress for Multiple Start and End Dates in MSExcel

    Started by valeriemt2‎, 08-09-2020 11:45 AM
    msexcel 1 Attachment(s)
    • 6
    • 3,931
    NotASuperGenius
    04-13-2021, 08:47 PM Go to last post

  23. How to extract and process data by date

    Started by Felissen‎, 04-09-2021 03:14 AM
    4 Attachment(s)
    • 7
    • 489
    JeteMc
    04-13-2021, 06:43 PM Go to last post

  24. SUM only if other column show number

    Started by Jamalou‎, 04-13-2021 05:09 PM
    1 Attachment(s)
    • 3
    • 333
    Jamalou
    04-13-2021, 05:32 PM Go to last post

  25. Sum active subscription by date

    Started by ignaciob‎, 04-13-2021 03:33 PM
    2 Attachment(s)
    • 2
    • 261
    ignaciob
    04-13-2021, 04:37 PM Go to last post

  26. Arrow Inventory Stock Allocation Formula

    Started by Sammiie29‎, 04-13-2021 03:31 PM
    #allocation, #formulas, #inventory 1 Attachment(s)
    • 1
    • 369
    JohnTopley
    04-13-2021, 03:50 PM Go to last post

  27. getting Values from a lookup list

    Started by derailed77‎, 04-13-2021 12:17 PM
    1 Attachment(s)
    • 5
    • 265
    Richard Buttrey
    04-13-2021, 03:27 PM Go to last post

  28. [SOLVED] Formula to Select Match Column

    Started by kevcombs‎, 04-13-2021 01:31 PM
    2 Attachment(s)
    • 1
    • 210
    ChemistB
    04-13-2021, 02:12 PM Go to last post

  29. [SOLVED] XLOOKUP when there are blanks in the data

    Started by Webbers‎, 04-13-2021 12:38 PM
    blanks, xlookup, zeros 2 Attachment(s)
    • 5
    • 1,019
    AliGW
    04-13-2021, 01:28 PM Go to last post

  30. carryover amount of vacation hours over and above allowed amount

    Started by amsarrazin‎, 04-13-2021 12:12 PM
    1 Attachment(s)
    • 5
    • 276
    JohnTopley
    04-13-2021, 01:21 PM Go to last post

  31. Help with Commission Calculation based on accelerator and attainment tier

    Started by pantsonfire123‎, 04-09-2021 11:43 AM
    1 Attachment(s)
    • 1
    • 738
    JeteMc
    04-13-2021, 11:49 AM Go to last post

  32. [SOLVED] Determine Payment Due Date with Submission Date

    Started by Hikari‎, 06-28-2018 03:28 AM
    2 Attachment(s)
    • 15
    • 774
    JeteMc
    04-13-2021, 10:37 AM Go to last post

  33. [SOLVED] Reconcile Bank Statement Forumla

    Started by willhh3‎, 03-11-2021 04:39 PM
    match with variables, reconcile 5 Attachment(s)
    • 12
    • 832
    sleek12
    04-13-2021, 10:04 AM Go to last post

  34. Post Look up value and match with data in separate tab

    Started by MSGSWOODS‎, 04-13-2021 09:46 AM
    1 Attachment(s)
    • 3
    • 237
    JohnTopley
    04-13-2021, 09:51 AM Go to last post

  35. MS Query - Deny Access to Data Source

    Started by Maroota‎, 04-13-2021 09:34 AM
    • 4
    • 207
    AliGW
    04-13-2021, 09:47 AM Go to last post

  36. [SOLVED] Need help with a Vlookup formula

    Started by Amy Duval 9‎, 04-12-2021 11:09 AM
    3 Attachment(s)
    • 6
    • 297
    AliGW
    04-13-2021, 09:23 AM Go to last post

  37. How can I pull a value from a cell if it finds a match

    Started by Terrier17‎, 04-13-2021 05:46 AM
    4 Attachment(s)
    • 5
    • 260
    Glenn Kennedy
    04-13-2021, 08:51 AM Go to last post

  38. Working Days / BLANK

    Started by HMIronist‎, 04-13-2021 07:30 AM
    • 4
    • 245
    AliGW
    04-13-2021, 08:32 AM Go to last post

  39. Minuites between 2 times

    Started by donkey_uk‎, 04-13-2021 05:16 AM
    • 1
    • 175
    AliGW
    04-13-2021, 05:19 AM Go to last post

  40. Index Match formula for Current liabilities and current assets

    Started by sunboy‎, 04-12-2021 06:03 AM
    5 Attachment(s)
    • 7
    • 456
    sunboy
    04-13-2021, 04:12 AM Go to last post

  41. [SOLVED] Difficult Formula Count Line date w/in Week and Hours charged

    Started by iqbalmel‎, 04-10-2021 09:28 PM
    2 Attachment(s)
    • 5
    • 434
    Glenn Kennedy
    04-13-2021, 02:36 AM Go to last post

  42. [SOLVED] + or - formula

    Started by bhenderson69‎, 04-12-2021 01:33 AM
    2 Attachment(s)
    • 11
    • 353
    Glenn Kennedy
    04-13-2021, 02:34 AM Go to last post

  43. [SOLVED] Arrange top 5 items from a list in decreasing order

    Started by chaliseyp‎, 04-12-2021 05:36 PM
    3 Attachment(s)
    • 4
    • 317
    Bo_Ry
    04-13-2021, 02:20 AM Go to last post

  44. Extracing Average Price

    Started by amado1975‎, 04-12-2021 08:15 PM
    1 Attachment(s)
    • 3
    • 272
    JohnTopley
    04-13-2021, 02:00 AM Go to last post

  45. passed dates into months columm

    Started by donkey_uk‎, 04-07-2021 10:31 AM
    2 Attachment(s)
    • 2
    • 329
    kvsrinivasamurthy
    04-13-2021, 12:39 AM Go to last post

  46. Auto fill a validated cell, if the condition not met

    Started by kusumoaji‎, 04-12-2021 11:43 PM
    data validation formula
    • 0
    • 273
    kusumoaji
    04-12-2021, 11:43 PM Go to last post

  47. [SOLVED] Trying to compare two columns and if they match add another columns data

    Started by Dena‎, 04-12-2021 12:42 AM
    1 Attachment(s)
    • 5
    • 431
    FDibbins
    04-12-2021, 11:16 PM Go to last post

  48. sorting and filter

    Started by wmcmahon45‎, 04-07-2021 05:18 PM
    2 Attachment(s)
    • 6
    • 306
    JeteMc
    04-12-2021, 07:12 PM Go to last post

  49. [SOLVED] I need my formula to display the result in reversed order

    Started by chrisneu‎, 04-12-2021 12:26 PM
    1 Attachment(s)
    • 3
    • 321
    FlameRetired
    04-12-2021, 06:39 PM Go to last post

  50. Fill Column 'AC' with Vegetable Names from Garden Grid Matching Adjacent Numbers

    Started by BobBrown60‎, 03-24-2021 02:10 PM
    • 3
    • 281
    alansidman
    04-12-2021, 05:45 PM Go to last post
+ Post New Thread
Page 511 of 5614 FirstFirst ... 511 ...

Forum Information and Options

Users Browsing this Forum

There are currently 63 users browsing this forum. (6 members & 57 guests)

  1. crazy8jacky,
  2. Glenn Kennedy,
  3. Gregb11,
  4. lilsnoop,
  5. mohammed20042,
  6. Root_

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