+ Post New Thread
Page 489 of 5614 FirstFirst ... 489 ...
Threads 24401 to 24450 of 280690

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. How to calculate percentages?

    Started by bagpuss‎, 05-23-2021 03:23 PM
    • 2
    • 372
    MarvinP
    05-23-2021, 08:53 PM Go to last post

  2. Formula for highest number in 1 column

    Started by lknights1987‎, 05-23-2021 10:20 AM
    formula 2 Attachment(s)
    • 4
    • 313
    JohnTopley
    05-23-2021, 10:38 AM Go to last post

  3. incremental increase in value

    Started by shamsu203‎, 05-23-2021 01:39 AM
    1 Attachment(s)
    • 5
    • 356
    AliGW
    05-23-2021, 10:03 AM Go to last post

  4. [SOLVED] Count a customer if they appear for sequential periods (by month), fresh count if not

    Started by AnnieMM‎, 05-23-2021 07:40 AM
    1 Attachment(s)
    • 3
    • 330
    AnnieMM
    05-23-2021, 08:35 AM Go to last post

  5. [SOLVED] Can numbers be colour coded using a formula

    Started by Shinas‎, 05-23-2021 08:24 AM
    • 2
    • 202
    JohnTopley
    05-23-2021, 08:27 AM Go to last post

  6. Post Help with formulas calculating card balances and payments

    Started by Svenn90‎, 05-23-2021 05:06 AM
    formulas, if formulas 1 Attachment(s)
    • 4
    • 456
    JohnTopley
    05-23-2021, 07:04 AM Go to last post

  7. Smile To Poulate Week numbers for a Month

    Started by GemBox‎, 05-23-2021 03:35 AM
    5 Attachment(s)
    • 14
    • 341
    AliGW
    05-23-2021, 05:59 AM Go to last post

  8. [SOLVED] Excel 2010/Automatically Transpose Data from one sheet to another

    Started by anandis‎, 05-22-2021 02:48 AM
    5 Attachment(s)
    • 6
    • 383
    anandis
    05-23-2021, 03:04 AM Go to last post

  9. using a SUM array to grade homework with multiple correct answers

    Started by ouboss‎, 05-21-2021 08:56 AM
    2 Attachment(s)
    • 6
    • 287
    FDibbins
    05-23-2021, 12:49 AM Go to last post

  10. Variables for formulas

    Started by ddietrich‎, 05-22-2021 02:51 PM
    2 Attachment(s)
    • 7
    • 290
    ddietrich
    05-22-2021, 08:20 PM Go to last post

  11. [SOLVED] Find Average Hours of Last N Months for Employee

    Started by Ebiru2387‎, 05-17-2021 03:46 PM
    2 Attachment(s)
    • 6
    • 270
    Ebiru2387
    05-22-2021, 07:37 PM Go to last post

  12. Post [SOLVED] SUMIFS 2 criteria - unable to compare date to month number

    Started by dad812‎, 05-22-2021 01:28 PM
    1 Attachment(s)
    • 8
    • 309
    Fluff13
    05-22-2021, 04:58 PM Go to last post

  13. [SOLVED] Change a number into text with the use of currency number format

    Started by sunboy‎, 05-22-2021 08:23 AM
    3 Attachment(s)
    • 8
    • 458
    sunboy
    05-22-2021, 04:00 PM Go to last post

  14. Question [SOLVED] How to find the correct value when considering two variables?

    Started by Daniel-1973‎, 05-22-2021 02:40 PM
    sorting advanced, variable criteria, vlook up problem 4 Attachment(s)
    • 10
    • 412
    Daniel-1973
    05-22-2021, 03:50 PM Go to last post

  15. Question Return percentage value if match two cell ranges text value same with condition

    Started by vppismail‎, 05-22-2021 01:23 PM
    excel formula, inspection plan, plan 1 Attachment(s)
    • 1
    • 378
    alansidman
    05-22-2021, 02:27 PM Go to last post

  16. Using a Text Value as Range by Indirect Function in a Vlookup to get a corresponding value

    Started by e4excel‎, 05-19-2021 04:17 AM
    3 Attachment(s)
    • 18
    • 486
    JohnTopley
    05-22-2021, 01:38 PM Go to last post

  17. [SOLVED] but i need two parameters instead of one =ALS.FOUT(INDEX(I:I;AGGREGAAT

    Started by langeloo‎, 05-21-2021 12:24 PM
    6 Attachment(s)
    • 10
    • 357
    langeloo
    05-22-2021, 11:17 AM Go to last post

  18. [SOLVED] how to use formula when the A column is blank.

    Started by sudhansu121‎, 05-22-2021 08:15 AM
    • 10
    • 296
    sudhansu121
    05-22-2021, 10:23 AM Go to last post

  19. [SOLVED] Calculate median from a partial set of data

    Started by SHAPESHIFTER‎, 05-17-2021 12:22 PM
    • 7
    • 394
    AliGW
    05-22-2021, 10:09 AM Go to last post

  20. extract data from sheets and copy them in one sheet

    Started by fakhteh‎, 05-21-2021 03:15 AM
    4 Attachment(s)
    • 4
    • 288
    Metoo7
    05-22-2021, 08:07 AM Go to last post

  21. Multiple IF AND/OR statements

    Started by aryaz327‎, 05-21-2021 01:35 PM
    • 5
    • 391
    Aardigspook
    05-22-2021, 07:45 AM Go to last post

  22. [SOLVED] SUMIFS returning 0 and I can't see why.

    Started by Anthony57‎, 05-22-2021 06:24 AM
    1 Attachment(s)
    • 5
    • 266
    AliGW
    05-22-2021, 07:20 AM Go to last post

  23. Can we add +2 to results of this formula but only in a date range?

    Started by Rober‎, 05-21-2021 01:45 PM
    1 Attachment(s)
    • 6
    • 306
    JohnTopley
    05-22-2021, 07:10 AM Go to last post

  24. [SOLVED] Get remarks value base on the CODE No. and Unique no.

    Started by jasond1992‎, 05-22-2021 02:57 AM
    4 Attachment(s)
    • 2
    • 265
    kvsrinivasamurthy
    05-22-2021, 04:44 AM Go to last post

  25. [SOLVED] Nested IF formula with conditions IF, AND, OR

    Started by Rober‎, 05-21-2021 12:26 AM
    • 5
    • 336
    kvsrinivasamurthy
    05-22-2021, 03:01 AM Go to last post

  26. [SOLVED] Help with combining if and countif in one function

    Started by Boheret5an‎, 05-21-2021 02:38 PM
    1 Attachment(s)
    • 12
    • 301
    JohnTopley
    05-22-2021, 02:58 AM Go to last post

  27. Countif help

    Started by gbhat‎, 05-22-2021 01:16 AM
    1 Attachment(s)
    • 3
    • 307
    Croweater
    05-22-2021, 01:34 AM Go to last post

  28. Thumbs up [SOLVED] VLOOKUP decided to give me N/A and doesn't want tell me why

    Started by kamil666‎, 05-22-2021 12:02 AM
    excel, numbers, vlookup 2 Attachment(s)
    • 9
    • 387
    kamil666
    05-22-2021, 01:03 AM Go to last post

  29. Question IF AND/OR formula help

    Started by gbhat‎, 05-10-2021 11:53 PM
    1 Attachment(s)
    • 5
    • 415
    gbhat
    05-22-2021, 12:52 AM Go to last post

  30. [SOLVED] Conditional format or data validation for an entered date&time based on another cell

    Started by grasshopper82‎, 05-19-2021 12:28 PM
    2 Attachment(s)
    • 2
    • 297
    grasshopper82
    05-21-2021, 09:56 PM Go to last post

  31. [SOLVED] I need to autofill a calendar (employee vacation) from a list I have

    Started by Reykjavik‎, 05-20-2021 07:39 AM
    2 Attachment(s)
    • 2
    • 330
    Reykjavik
    05-21-2021, 07:45 PM Go to last post

  32. [SOLVED] Multiple results according to multiple criteria and the right column

    Started by Sybille‎, 04-26-2021 04:44 PM
    3 Attachment(s)
    • 5
    • 383
    JeteMc
    05-21-2021, 06:46 PM Go to last post

  33. dragging formula

    Started by Boheret5an‎, 05-21-2021 04:18 PM
    • 1
    • 213
    dohvakin123
    05-21-2021, 05:13 PM Go to last post

  34. [SOLVED] Need help with a formula to give Pass/Fail results for items with different limits

    Started by Stryfe‎, 05-21-2021 02:46 PM
    2 Attachment(s)
    • 4
    • 248
    JohnTopley
    05-21-2021, 03:50 PM Go to last post

  35. Formula to combine numbers

    Started by XxTENTatioN‎, 05-21-2021 02:07 PM
    2 Attachment(s)
    • 0
    • 500
    XxTENTatioN
    05-21-2021, 02:07 PM Go to last post

  36. [SOLVED] Trying to pull additional source data using SSN as the common value from source

    Started by MiserableShake0‎, 05-21-2021 08:19 AM
    1 Attachment(s)
    • 5
    • 254
    MiserableShake0
    05-21-2021, 02:01 PM Go to last post

  37. Combine 2 rows into 1 cell

    Started by nzkf‎, 05-19-2021 10:50 AM
    3 Attachment(s)
    • 3
    • 316
    sintek
    05-21-2021, 01:50 PM Go to last post

  38. [SOLVED] Sum with duplicates, dates and max

    Started by Sybille‎, 05-21-2021 10:16 AM
    4 Attachment(s)
    • 5
    • 297
    Sybille
    05-21-2021, 01:42 PM Go to last post

  39. [SOLVED] Date range search where there is overlap

    Started by MephistophelesUK‎, 05-20-2021 10:49 AM
    3 Attachment(s)
    • 8
    • 362
    kvsrinivasamurthy
    05-21-2021, 12:52 PM Go to last post

  40. [SOLVED] Formulas to extract data applicable to a particular finance house

    Started by Howardc1001‎, 05-21-2021 09:49 AM
    1 Attachment(s)
    • 5
    • 306
    Howardc1001
    05-21-2021, 12:26 PM Go to last post

  41. Data validation using an IF?

    Started by Weaselwithagun‎, 05-21-2021 11:18 AM
    • 1
    • 241
    JohnTopley
    05-21-2021, 11:25 AM Go to last post

  42. Exclamation Compare Sheet 2 with Sheet 1 - Populate Sheet 1 with e-mail address from Sheet 2.

    Started by ExcelFan23‎, 05-21-2021 11:02 AM
    1 Attachment(s)
    • 5
    • 260
    Pete_UK
    05-21-2021, 11:23 AM Go to last post

  43. automatically add newly created column headers to new row in another table

    Started by ouboss‎, 05-21-2021 08:35 AM
    1 Attachment(s)
    • 1
    • 239
    JohnTopley
    05-21-2021, 11:15 AM Go to last post

  44. Drop down assistance to work out waste percent

    Started by scrumpywill‎, 05-17-2021 12:14 PM
    2 Attachment(s)
    • 5
    • 276
    JohnTopley
    05-21-2021, 11:01 AM Go to last post

  45. Want to create a function if value is already there in table then return message

    Started by gxprocord‎, 05-21-2021 02:48 AM
    excel 1 Attachment(s)
    • 3
    • 241
    Eastw00d
    05-21-2021, 10:52 AM Go to last post

  46. Formula to insert multiple dates

    Started by rayted‎, 05-21-2021 04:02 AM
    dates 2 Attachment(s)
    • 13
    • 594
    Bo_Ry
    05-21-2021, 10:23 AM Go to last post

  47. [SOLVED] Counting Text on Middle Line of Cell Content

    Started by AliGW‎, 05-21-2021 08:39 AM
    2 Attachment(s)
    • 5
    • 215
    Fluff13
    05-21-2021, 08:57 AM Go to last post

  48. automatically input pupil id when i type a pupils name

    Started by welsh_decs‎, 05-21-2021 08:12 AM
    2 Attachment(s)
    • 7
    • 232
    AliGW
    05-21-2021, 08:42 AM Go to last post

  49. Month on Month Growth and Rev.

    Started by kashh83‎, 05-21-2021 05:40 AM
    1 Attachment(s)
    • 5
    • 367
    AliGW
    05-21-2021, 08:32 AM Go to last post

  50. Re: Request for Guidance about sorting the data

    Started by Hazratgi‎, 05-17-2021 09:09 AM
    3 Attachment(s)
    • 5
    • 283
    JeteMc
    05-21-2021, 08:16 AM Go to last post
+ Post New Thread
Page 489 of 5614 FirstFirst ... 489 ...

Forum Information and Options

Users Browsing this Forum

There are currently 52 users browsing this forum. (2 members & 50 guests)

  1. AliGW,
  2. Phuocam

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