+ Post New Thread
Page 541 of 5614 FirstFirst ... 541 ...
Threads 27001 to 27050 of 280691

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. Addition depends on two variable values

    Started by pradeepswalse‎, 02-20-2021 01:45 PM
    addition 3 Attachment(s)
    • 7
    • 374
    JohnTopley
    02-24-2021, 08:24 AM Go to last post

  2. adding a column of euros

    Started by btman‎, 02-24-2021 07:46 AM
    1 Attachment(s)
    • 1
    • 212
    samba_ravi
    02-24-2021, 08:02 AM Go to last post

  3. [SOLVED] Help with IF Statement to Deal with Different Pricing Criteria

    Started by Redlittle‎, 02-24-2021 07:48 AM
    • 1
    • 221
    AliGW
    02-24-2021, 07:50 AM Go to last post

  4. [SOLVED] Formula for searching/selecting specific information between different tabs on spreadsheet

    Started by Laura2988‎, 02-24-2021 07:31 AM
    1 Attachment(s)
    • 1
    • 186
    Laura2988
    02-24-2021, 07:41 AM Go to last post

  5. [SOLVED] Count unique values when cells contain multiple values

    Started by peterderrington‎, 02-24-2021 05:43 AM
    3 Attachment(s)
    • 10
    • 299
    peterderrington
    02-24-2021, 07:39 AM Go to last post

  6. Question [SOLVED] Add percent increase or decrease depending the value

    Started by dapeben480‎, 02-24-2021 04:05 AM
    2 Attachment(s)
    • 10
    • 356
    dapeben480
    02-24-2021, 07:12 AM Go to last post

  7. [SOLVED] Divide costs evenly on values with similar prefix

    Started by Amadan90‎, 02-19-2021 12:13 PM
    4 Attachment(s)
    • 11
    • 488
    Glenn Kennedy
    02-24-2021, 07:01 AM Go to last post

  8. Index Match with multiple criteria returns and error

    Started by mattdamon33‎, 02-24-2021 04:53 AM
    • 2
    • 267
    mattdamon33
    02-24-2021, 06:13 AM Go to last post

  9. Question Looking for formula to search a previous value from specific time frame

    Started by GoldenChicken‎, 02-24-2021 03:52 AM
    2 Attachment(s)
    • 4
    • 254
    GoldenChicken
    02-24-2021, 05:57 AM Go to last post

  10. [SOLVED] Find the input value that give the minumum result

    Started by DaveEssex‎, 02-23-2021 07:00 AM
    solved thanks 4 Attachment(s)
    • 14
    • 410
    JohnTopley
    02-24-2021, 04:33 AM Go to last post

  11. Question Index and Match - multiple items multiple tabs/sheets

    Started by cmpx23‎, 02-23-2021 02:24 PM
    2 Attachment(s)
    • 3
    • 244
    Glenn Kennedy
    02-24-2021, 04:06 AM Go to last post

  12. Cell value doesn't change if the result is an error

    Started by chaliseyp‎, 02-24-2021 03:21 AM
    • 1
    • 163
    samba_ravi
    02-24-2021, 03:35 AM Go to last post

  13. Angry [SOLVED] Need guidance as to how to look up values with multiple qualifiers

    Started by DesertMJ‎, 02-24-2021 02:38 AM
    if=then, match & index, xlookup 1 Attachment(s)
    • 4
    • 419
    DesertMJ
    02-24-2021, 03:16 AM Go to last post

  14. Question Find a price from mulitple sheets based on item type, width, & height

    Started by Aperrin198‎, 02-24-2021 01:04 AM
    ceiling, index, match 1 Attachment(s)
    • 1
    • 309
    bebo021999
    02-24-2021, 02:35 AM Go to last post

  15. [SOLVED] Populate the Amount of one cell into the corresponding amount in column

    Started by shawnsdad‎, 02-17-2021 09:33 PM
    automation, population 1 Attachment(s)
    • 5
    • 520
    FDibbins
    02-24-2021, 01:09 AM Go to last post

  16. Need help with dynamic sheet reference

    Started by DerNuB‎, 02-23-2021 11:22 PM
    1 Attachment(s)
    • 1
    • 204
    DerNuB
    02-24-2021, 12:36 AM Go to last post

  17. Exclamation [SOLVED] How to start to recount once a condition is met?

    Started by PeterHan123‎, 02-23-2021 06:01 AM
    1 Attachment(s)
    • 2
    • 279
    PeterHan123
    02-23-2021, 09:15 PM Go to last post

  18. [SOLVED] How to use Vlookup(TRUE) to extract values?

    Started by q988988‎, 02-21-2021 09:20 PM
    6 Attachment(s)
    • 10
    • 475
    q988988
    02-23-2021, 07:26 PM Go to last post

  19. [SOLVED] Count line if not Sunday and show zero if line empty

    Started by JENSENGT74‎, 02-22-2021 02:36 PM
    1 Attachment(s)
    • 7
    • 314
    JENSENGT74
    02-23-2021, 06:23 PM Go to last post

  20. [SOLVED] PERCENTILE.EXC across multiple tabs

    Started by rlhchung‎, 02-23-2021 02:55 AM
    • 4
    • 555
    Glenn Kennedy
    02-23-2021, 06:14 PM Go to last post

  21. [SOLVED] sumif/sumifs to sum one row below criteria row

    Started by sadgtq84wtohasd‎, 02-23-2021 11:45 AM
    • 3
    • 437
    ChemistB
    02-23-2021, 05:44 PM Go to last post

  22. Allocating multiple Quantities items into multiple pots based on cost.

    Started by RobLaw85‎, 02-05-2021 12:06 PM
    4 Attachment(s)
    • 7
    • 509
    Alf
    02-23-2021, 04:32 PM Go to last post

  23. [SOLVED] Appending prefixes back onto values from larger list

    Started by frznlogr‎, 02-22-2021 03:53 PM
    • 6
    • 313
    maniacb
    02-23-2021, 04:24 PM Go to last post

  24. [SOLVED] #VALUE! Error Using a Triple Nested SUBSTITUTE Formula, ERROR DUE TO EMPTY CELL(S)

    Started by skite0‎, 02-23-2021 03:53 PM
    #value!, formula, substitute, sum - range of cells 2 Attachment(s)
    • 3
    • 409
    Fluff13
    02-23-2021, 04:13 PM Go to last post

  25. [SOLVED] Extract from Tables from multiple tabs: One Workbook

    Started by d7882‎, 02-08-2021 01:25 PM
    index & match, table array 7 Attachment(s)
    • 29
    • 1,265
    Limor_OP
    02-23-2021, 04:00 PM Go to last post

  26. [SOLVED] Using formula result as limit for another formula

    Started by Doc16743‎, 02-23-2021 01:57 PM
    • 5
    • 268
    Doc16743
    02-23-2021, 03:26 PM Go to last post

  27. How to add unique and duplicate values in Excel

    Started by specy_99‎, 02-23-2021 10:19 AM
    • 4
    • 220
    specy_99
    02-23-2021, 02:58 PM Go to last post

  28. Can anyone help on amending a formula.

    Started by tweacle‎, 02-23-2021 08:38 AM
    • 3
    • 234
    tweacle
    02-23-2021, 02:31 PM Go to last post

  29. Question [SOLVED] Date plus 3 years and set to red

    Started by Sharr76‎, 02-17-2021 03:36 PM
    2 Attachment(s)
    • 5
    • 447
    Aardigspook
    02-23-2021, 02:16 PM Go to last post

  30. [SOLVED] Summing numbers in a column range (X1...Xn) that may contain a non number character

    Started by skite0‎, 02-23-2021 01:11 PM
    conditional formatting, formula, number and text, sum - range of cells 2 Attachment(s)
    • 6
    • 452
    Glenn Kennedy
    02-23-2021, 02:12 PM Go to last post

  31. [SOLVED] Change If/VLOOKUP Formula to not return #N/A

    Started by msdclark‎, 02-22-2021 07:24 PM
    • 2
    • 233
    msdclark
    02-23-2021, 01:57 PM Go to last post

  32. Question looking for a possible simpler solution (formula) to calculate ~cashflow from customers

    Started by neveum‎, 02-18-2021 01:52 PM
    cashflow, customer, formula, revenue 4 Attachment(s)
    • 3
    • 610
    Ochimus
    02-23-2021, 01:34 PM Go to last post

  33. [SOLVED] Remove duplicate and place on one row

    Started by Tobbe97‎, 02-23-2021 12:29 PM
    3 Attachment(s)
    • 6
    • 287
    Glenn Kennedy
    02-23-2021, 01:23 PM Go to last post

  34. Conditional formula that "value" gets in the way of

    Started by staustell‎, 02-23-2021 07:49 AM
    1 Attachment(s)
    • 6
    • 250
    TMS
    02-23-2021, 01:09 PM Go to last post

  35. Select two numbers appearance count them and put the count on another sheet.

    Started by Shinas‎, 02-20-2021 03:07 PM
    3 Attachment(s)
    • 13
    • 602
    Shinas
    02-23-2021, 01:00 PM Go to last post

  36. [SOLVED] Count totals of dates per location

    Started by kieranm105‎, 02-23-2021 11:45 AM
    1 Attachment(s)
    • 2
    • 186
    kieranm105
    02-23-2021, 12:27 PM Go to last post

  37. [SOLVED] Blank cell not blank

    Started by Len Silva‎, 02-23-2021 09:07 AM
    1 Attachment(s)
    • 11
    • 302
    Pete_UK
    02-23-2021, 12:26 PM Go to last post

  38. [SOLVED] Importing From Access

    Started by Cobra17‎, 02-11-2021 10:48 AM
    • 6
    • 289
    Cobra17
    02-23-2021, 12:15 PM Go to last post

  39. Large Array for top 5 % Completes

    Started by jharvey87‎, 02-23-2021 10:20 AM
    3 Attachment(s)
    • 9
    • 382
    XLent
    02-23-2021, 12:03 PM Go to last post

  40. [SOLVED] list all cells in a row with values greater than zero by column header and value

    Started by tomaszevsky‎, 09-30-2012 01:30 AM
    2 Attachment(s)
    • 6
    • 6,070
    PC_excl
    02-23-2021, 11:37 AM Go to last post

  41. Need help with Dates Incremented by .25 days, and excluding weekends.

    Started by highlandranger‎, 02-22-2021 08:38 PM
    3 Attachment(s)
    • 11
    • 390
    highlandranger
    02-23-2021, 11:36 AM Go to last post

  42. [SOLVED] Need to extract data and skip blanks

    Started by Dawn Clark‎, 08-24-2020 12:16 PM
    7 Attachment(s)
    • 20
    • 818
    JeteMc
    02-23-2021, 11:18 AM Go to last post

  43. Conditional formatting - multiple conditions

    Started by radekrat‎, 02-22-2021 05:28 PM
    1 Attachment(s)
    • 7
    • 266
    radekrat
    02-23-2021, 10:59 AM Go to last post

  44. Question Need a whole row of Data placed into separate sheet based on one cell's criteria in Row.

    Started by i3 Data Hound‎, 02-19-2021 05:04 PM
    3 Attachment(s)
    • 11
    • 509
    i3 Data Hound
    02-23-2021, 10:59 AM Go to last post

  45. How can I do a conditional format to change the color when my formula shows a "loss" ?

    Started by Gebo‎, 02-23-2021 10:28 AM
    • 2
    • 246
    Gebo
    02-23-2021, 10:52 AM Go to last post

  46. How to add up a multiple choice quiz with different score for each answer

    Started by Myles-C‎, 02-23-2021 07:32 AM
    1 Attachment(s)
    • 8
    • 1,351
    Myles-C
    02-23-2021, 10:39 AM Go to last post

  47. Count total cells meeting 2 criteria

    Started by yug0man‎, 02-22-2021 12:58 PM
    5 Attachment(s)
    • 10
    • 399
    yug0man
    02-23-2021, 10:23 AM Go to last post

  48. [SOLVED] Creating a "spread" every time a dummy changes

    Started by Excelnick96‎, 02-19-2021 06:33 AM
    function, if formula 3 Attachment(s)
    • 6
    • 601
    JeteMc
    02-23-2021, 09:55 AM Go to last post

  49. Only count working days for overlapping date ranges

    Started by naj1990‎, 02-23-2021 06:47 AM
    date & time calculation, date and between, excel
    • 2
    • 598
    naj1990
    02-23-2021, 09:52 AM Go to last post

  50. [SOLVED] Updating cell value based on the date

    Started by Bidmas‎, 02-22-2021 11:52 AM
    date & value, formula, last value
    • 2
    • 351
    Bidmas
    02-23-2021, 08:55 AM Go to last post
+ Post New Thread
Page 541 of 5614 FirstFirst ... 541 ...

Forum Information and Options

Users Browsing this Forum

There are currently 44 users browsing this forum. (0 members & 44 guests)

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