+ Post New Thread
Page 1010 of 5614 FirstFirst ... 1010 ...
Threads 50451 to 50500 of 280698

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

  1. Searching for name in another sheet & pulling heading info from column name appears in

    Started by pricejw‎, 02-07-2019 08:57 PM
    • 1
    • 226
    pricejw
    02-08-2019, 10:35 AM Go to last post

  2. [SOLVED] Finding Dates Within Date Range (Based on Today's Date) Whilst Matching Name?

    Started by EduardStoo‎, 02-07-2019 06:14 AM
    3 Attachment(s)
    • 9
    • 435
    Pete_UK
    02-08-2019, 10:31 AM Go to last post

  3. Lookup function returning a value to a cell but you can not see the formula in that cell

    Started by davidk22‎, 02-08-2019 09:18 AM
    • 2
    • 212
    PaulSP8
    02-08-2019, 09:40 AM Go to last post

  4. [SOLVED] Include percentage in Pivot

    Started by rchure‎, 02-08-2019 05:11 AM
    3 Attachment(s)
    • 4
    • 248
    rchure
    02-08-2019, 09:32 AM Go to last post

  5. win streak formula

    Started by silkpantsman‎, 02-08-2019 07:40 AM
    1 Attachment(s)
    • 7
    • 345
    Bo_Ry
    02-08-2019, 09:27 AM Go to last post

  6. Formula to reference sheet vs sheet name

    Started by NU2vba‎, 02-07-2019 03:22 PM
    • 10
    • 659
    Fluff13
    02-08-2019, 08:51 AM Go to last post

  7. [SOLVED] Another Index Match

    Started by Gazsim‎, 02-08-2019 06:32 AM
    1 Attachment(s)
    • 2
    • 265
    Bo_Ry
    02-08-2019, 08:11 AM Go to last post

  8. Angry Find Value Within Range of Data

    Started by bp2e‎, 02-07-2019 03:54 PM
    nested if's, vlook-up 1 Attachment(s)
    • 1
    • 311
    TMS
    02-08-2019, 07:42 AM Go to last post

  9. [SOLVED] Adding cells that contain specific letters

    Started by TG215‎, 02-07-2019 09:05 AM
    1 Attachment(s)
    • 5
    • 357
    Pete_UK
    02-08-2019, 06:34 AM Go to last post

  10. Conditional formatting not working

    Started by archimaitreya‎, 02-08-2019 05:25 AM
    1 Attachment(s)
    • 2
    • 254
    archimaitreya
    02-08-2019, 05:47 AM Go to last post

  11. How to formulate merged cells?

    Started by jinmatahari‎, 02-07-2019 04:59 PM
    1 Attachment(s)
    • 5
    • 376
    Bo_Ry
    02-08-2019, 05:41 AM Go to last post

  12. Conditional Formating Based on Select Cells Above

    Started by DarkNiiinja‎, 02-08-2019 04:51 AM
    condidional format, condiitonal formatting, condition format, condition formatting, formula assistance
    • 3
    • 392
    FDibbins
    02-08-2019, 05:03 AM Go to last post

  13. [SOLVED] Formula, Excel, Monthly Invoice,

    Started by dude6571‎, 02-08-2019 03:37 AM
    2 Attachment(s)
    • 1
    • 349
    Bo_Ry
    02-08-2019, 04:38 AM Go to last post

  14. Automatically add data from a table to a simple calendar

    Started by Kevibu‎, 02-07-2019 03:57 PM
    calendar, formula and functions, table data 1 Attachment(s)
    • 2
    • 487
    Kevibu
    02-08-2019, 04:36 AM Go to last post

  15. Smile replace formula in more rows

    Started by vasc‎, 02-07-2019 11:45 AM
    1 Attachment(s)
    • 1
    • 243
    vasc
    02-08-2019, 03:25 AM Go to last post

  16. [SOLVED] Ranking using multiple criteria

    Started by pentabarf‎, 02-07-2019 01:49 PM
    7 Attachment(s)
    • 10
    • 474
    pentabarf
    02-08-2019, 12:57 AM Go to last post

  17. [SOLVED] Extracting color name from a string.

    Started by roxdrob01‎, 02-07-2019 11:26 PM
    • 6
    • 754
    roxdrob01
    02-08-2019, 12:23 AM Go to last post

  18. If function last day travel

    Started by MarkM123‎, 02-07-2019 10:48 PM
    formula 2 Attachment(s)
    • 1
    • 291
    jme1013
    02-08-2019, 12:02 AM Go to last post

  19. Conditional formatting using COUNTIF and AND/OR functions

    Started by dchen95‎, 02-07-2019 10:29 PM
    1 Attachment(s)
    • 1
    • 211
    TMS
    02-07-2019, 11:42 PM Go to last post

  20. [SOLVED] Formula for Clause Point System - E.g. Clause 1 = 10 points, Clause 2 = 5 Points

    Started by petsean007‎, 02-07-2019 09:23 PM
    2 Attachment(s)
    • 3
    • 372
    petsean007
    02-07-2019, 11:05 PM Go to last post

  21. IF Formulas - Gantt Chart

    Started by Juddman79‎, 02-07-2019 03:15 AM
    • 4
    • 572
    Pete_UK
    02-07-2019, 09:47 PM Go to last post

  22. Multiple IF and AND Statments

    Started by SBLR01‎, 02-06-2019 06:57 PM
    1 Attachment(s)
    • 4
    • 286
    protonLeah
    02-07-2019, 08:58 PM Go to last post

  23. Assign value or point for each active hour..

    Started by 1053857‎, 02-07-2019 06:17 PM
    • 1
    • 191
    KOKOSEK
    02-07-2019, 08:09 PM Go to last post

  24. [SOLVED] If 2 Cells Do Not Match Return Error Message

    Started by dgarber‎, 02-07-2019 05:23 PM
    2 Attachment(s)
    • 1
    • 1,157
    6StringJazzer
    02-07-2019, 07:19 PM Go to last post

  25. [SOLVED] toggle checkbox based on cell value

    Started by bambamclint‎, 02-07-2019 04:47 PM
    • 4
    • 416
    EchoPassenger
    02-07-2019, 07:07 PM Go to last post

  26. How to craft a nutritional spreadsheet

    Started by Quietbeat‎, 02-07-2019 06:18 PM
    1 Attachment(s)
    • 1
    • 290
    EchoPassenger
    02-07-2019, 06:45 PM Go to last post

  27. Formula for Calculating Optimum Ethernet Switches

    Started by JamieGEnt‎, 02-07-2019 10:21 AM
    newbie configuration size
    • 3
    • 246
    FlameRetired
    02-07-2019, 06:12 PM Go to last post

  28. [SOLVED] Match company names and return highest Overdue status

    Started by petsean007‎, 02-06-2019 07:49 PM
    1 Attachment(s)
    • 3
    • 393
    FlameRetired
    02-07-2019, 05:38 PM Go to last post

  29. [SOLVED] Compare Non Exact value from 2column and copy value

    Started by Noren Tumaisuri‎, 02-07-2019 04:44 PM
    1 Attachment(s)
    • 4
    • 264
    KOKOSEK
    02-07-2019, 05:16 PM Go to last post

  30. [SOLVED] IF value is in cell return 0 if not then return value from a selected cell

    Started by TAMMY32‎, 02-07-2019 04:55 PM
    1 Attachment(s)
    • 4
    • 670
    KOKOSEK
    02-07-2019, 05:13 PM Go to last post

  31. Calculate Vacations Holidays (PTO Accural Hours)

    Started by jclopez36324‎, 02-07-2019 01:15 PM
    2 Attachment(s)
    • 1
    • 323
    dflak
    02-07-2019, 05:13 PM Go to last post

  32. Urgent Help please

    Started by abac‎, 02-07-2019 05:06 PM
    • 1
    • 185
    alansidman
    02-07-2019, 05:09 PM Go to last post

  33. [SOLVED] Index / Match with Multiple Criteria

    Started by Gazsim‎, 02-07-2019 07:24 AM
    4 Attachment(s)
    • 7
    • 374
    FlameRetired
    02-07-2019, 04:39 PM Go to last post

  34. Trying to lock an entire row together for sorting.

    Started by GaryF‎, 02-06-2019 05:27 PM
    2 Attachment(s)
    • 6
    • 373
    EchoPassenger
    02-07-2019, 04:30 PM Go to last post

  35. Truncate Contents of a Cell from the Right

    Started by bsm726‎, 02-07-2019 02:08 PM
    trim, truncate
    • 9
    • 782
    Fluff13
    02-07-2019, 04:22 PM Go to last post

  36. Question Help with formula if cells have a value.

    Started by afprinter‎, 02-07-2019 02:43 PM
    1 Attachment(s)
    • 1
    • 204
    Aardigspook
    02-07-2019, 03:35 PM Go to last post

  37. Count names in one column if set values in two other columns..good luck!

    Started by ARFord‎, 02-07-2019 03:19 PM
    • 1
    • 183
    AliGW
    02-07-2019, 03:21 PM Go to last post

  38. Is there a way for me to treat multi-row entries as one or to certain rows move together

    Started by helloworkitt‎, 01-31-2019 06:50 PM
    2 Attachment(s)
    • 6
    • 466
    helloworkitt
    02-07-2019, 03:19 PM Go to last post

  39. [SOLVED] SUMIFS with date range using AND()

    Started by Watchman89‎, 02-06-2019 02:21 PM
    4 Attachment(s)
    • 11
    • 522
    Aardigspook
    02-07-2019, 03:00 PM Go to last post

  40. Named Range Formatting Help

    Started by dyee4613‎, 02-06-2019 06:57 PM
    • 4
    • 252
    dyee4613
    02-07-2019, 02:25 PM Go to last post

  41. [SOLVED] Date formatting trouble

    Started by Alex222‎, 02-07-2019 01:12 PM
    • 7
    • 240
    Alex222
    02-07-2019, 02:14 PM Go to last post

  42. [SOLVED] Combining IF with Concatenate

    Started by Syl1017‎, 02-07-2019 10:34 AM
    3 Attachment(s)
    • 9
    • 387
    Syl1017
    02-07-2019, 01:49 PM Go to last post

  43. [SOLVED] Countif with index and match ?

    Started by Ron Purpura‎, 02-07-2019 12:43 PM
    1 Attachment(s)
    • 2
    • 207
    Ron Purpura
    02-07-2019, 01:09 PM Go to last post

  44. [SOLVED] Adding a zero?

    Started by Losguapos1‎, 02-07-2019 12:31 PM
    • 4
    • 197
    Pete_UK
    02-07-2019, 12:37 PM Go to last post

  45. [SOLVED] How to Autosum values based on page number?

    Started by grim72‎, 02-07-2019 12:13 PM
    1 Attachment(s)
    • 4
    • 219
    Fluff13
    02-07-2019, 12:31 PM Go to last post

  46. Function to sum mixed text/numbers filtered by multiple criteria excluding strikethrough

    Started by darkshaddow‎, 02-06-2019 07:01 PM
    function, strikethrough, sumifs, sumproduct conditinal sum, udf 1 Attachment(s)
    • 2
    • 530
    darkshaddow
    02-07-2019, 11:30 AM Go to last post

  47. Lookup value based on minimum Height and Width

    Started by sanderb1‎, 02-06-2019 09:15 PM
    array, lookup, match, min 3 Attachment(s)
    • 4
    • 699
    sanderb1
    02-07-2019, 11:20 AM Go to last post

  48. Calculating rental period and cost

    Started by JustMax‎, 02-06-2019 05:24 PM
    dates, dates calculation
    • 1
    • 4,296
    etaf
    02-07-2019, 11:05 AM Go to last post

  49. Forumla to create a acronym "satus" column

    Started by Alexandre23‎, 02-06-2019 06:03 AM
    4 Attachment(s)
    • 5
    • 240
    Alexandre23
    02-07-2019, 10:22 AM Go to last post

  50. Auto fill cells depending on value of cell X

    Started by kevinwuyts‎, 02-07-2019 09:53 AM
    2 Attachment(s)
    • 4
    • 246
    kevinwuyts
    02-07-2019, 10:09 AM Go to last post
+ Post New Thread
Page 1010 of 5614 FirstFirst ... 1010 ...

Forum Information and Options

Users Browsing this Forum

There are currently 56 users browsing this forum. (3 members & 53 guests)

  1. HansDouwe,
  2. MrShorty,
  3. Rick Rothstein

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