+ Post New Thread
Page 500 of 5613 FirstFirst ... 500 ...
Threads 24951 to 25000 of 280610

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

  1. [SOLVED] Require Formula to find date (data) on another sheet and input data from cell below

    Started by GolfNut39‎, 04-28-2021 07:09 PM
    2 Attachment(s)
    • 5
    • 319
    Pete_UK
    04-30-2021, 08:04 PM Go to last post

  2. Formula to copy and paste cell data when a condition is met.

    Started by ashishpatel34‎, 04-30-2021 05:17 PM
    1 Attachment(s)
    • 1
    • 300
    TMS
    04-30-2021, 06:48 PM Go to last post

  3. [SOLVED] Using If cell not empty as criteria within a SUMIFS statement

    Started by pptdgc1999‎, 04-28-2021 12:10 PM
    1 Attachment(s)
    • 23
    • 679
    JohnTopley
    04-30-2021, 04:57 PM Go to last post

  4. [SOLVED] Concatenate 2 numbers and keep a "000000.00" format

    Started by weareallstardust‎, 04-30-2021 11:43 AM
    concatenate, join 2 Attachment(s)
    • 4
    • 483
    AliGW
    04-30-2021, 04:03 PM Go to last post

  5. Calculate total hours scheduled each hours of the day

    Started by Trippi‎, 04-27-2021 04:35 PM
    6 Attachment(s)
    • 23
    • 654
    FlameRetired
    04-30-2021, 02:58 PM Go to last post

  6. Using IF AND OR

    Started by PropTrd‎, 04-30-2021 02:18 PM
    • 4
    • 216
    Fluff13
    04-30-2021, 02:30 PM Go to last post

  7. How to extract Text and Numbers from a Cell

    Started by acandan21‎, 04-27-2021 01:07 PM
    • 4
    • 362
    ChemistB
    04-30-2021, 02:10 PM Go to last post

  8. [SOLVED] Match to 3 criteria the return results

    Started by JennOlsen‎, 04-30-2021 12:32 PM
    2 Attachment(s)
    • 2
    • 223
    JennOlsen
    04-30-2021, 12:59 PM Go to last post

  9. Sum total by year , user

    Started by booney440‎, 04-30-2021 09:45 AM
    excel & formula 5 Attachment(s)
    • 6
    • 331
    etaf
    04-30-2021, 12:45 PM Go to last post

  10. Question Check if row is valid based on multiple criteria from range...

    Started by JMHenriques‎, 04-30-2021 12:29 PM
    2 Attachment(s)
    • 1
    • 220
    JohnTopley
    04-30-2021, 12:31 PM Go to last post

  11. [SOLVED] Formulas Not Increasing Properly in Table

    Started by sussington‎, 04-28-2021 11:19 AM
    2 Attachment(s)
    • 8
    • 282
    cubangt
    04-30-2021, 12:12 PM Go to last post

  12. [SOLVED] Address cell to reference row

    Started by WAAZUPEE‎, 04-30-2021 10:57 AM
    1 Attachment(s)
    • 4
    • 283
    WAAZUPEE
    04-30-2021, 11:42 AM Go to last post

  13. [SOLVED] Formula to find entries with duplicate value in one column AND differing value in another

    Started by MadMaxineisMad‎, 04-28-2021 05:13 PM
    2 Attachment(s)
    • 7
    • 307
    MadMaxineisMad
    04-30-2021, 09:45 AM Go to last post

  14. Post [SOLVED] Adding a conditional IF to a VLOOKUP function formula

    Started by Khaldon‎, 04-30-2021 07:04 AM
    1 Attachment(s)
    • 3
    • 271
    Sam Capricci
    04-30-2021, 07:39 AM Go to last post

  15. Formula calculating values depending on value in drop down list.

    Started by urr100‎, 04-30-2021 06:45 AM
    2 Attachment(s)
    • 1
    • 188
    JohnTopley
    04-30-2021, 07:36 AM Go to last post

  16. [SOLVED] list of unique Scrip Name

    Started by btparkhe1920‎, 04-30-2021 03:10 AM
    1 Attachment(s)
    • 8
    • 353
    JohnTopley
    04-30-2021, 07:35 AM Go to last post

  17. Put data into different cell

    Started by gmarquis‎, 04-30-2021 06:10 AM
    • 5
    • 237
    JohnTopley
    04-30-2021, 07:20 AM Go to last post

  18. Link an image to cell value to display specific images

    Started by Peter Morgan‎, 04-27-2021 11:31 AM
    2 Attachment(s)
    • 5
    • 342
    Peter Morgan
    04-30-2021, 07:03 AM Go to last post

  19. Search for a text and then search for another text after the row containing the first text

    Started by ajeshkdy‎, 04-30-2021 05:33 AM
    1 Attachment(s)
    • 2
    • 258
    ajeshkdy
    04-30-2021, 06:10 AM Go to last post

  20. Combine data from two columns

    Started by Even‎, 04-28-2021 04:38 AM
    5 Attachment(s)
    • 15
    • 478
    Even
    04-30-2021, 06:06 AM Go to last post

  21. [SOLVED] Highlight column of current weeknumber

    Started by PatrickEasy‎, 04-28-2021 10:04 AM
    1 Attachment(s)
    • 5
    • 1,608
    PatrickEasy
    04-30-2021, 05:14 AM Go to last post

  22. Question [SOLVED] Counting specific value when various are within cell?

    Started by digbee‎, 04-30-2021 04:22 AM
    formula, ifs formula, ifstatement 1 Attachment(s)
    • 3
    • 321
    digbee
    04-30-2021, 04:38 AM Go to last post

  23. Summing Multiple Row of Data

    Started by mark2323‎, 04-29-2021 03:06 PM
    2 Attachment(s)
    • 4
    • 260
    kvsrinivasamurthy
    04-30-2021, 04:05 AM Go to last post

  24. [SOLVED] formula for the revenue row that evenly spreads each months bookings

    Started by Thor222‎, 04-29-2021 09:58 PM
    offset 5 Attachment(s)
    • 31
    • 814
    kvsrinivasamurthy
    04-30-2021, 03:27 AM Go to last post

  25. [SOLVED] IFS formula reading over 10 columns

    Started by JChandler8314‎, 04-29-2021 06:52 AM
    1 Attachment(s)
    • 5
    • 266
    BadlySpelledBuoy
    04-30-2021, 03:10 AM Go to last post

  26. 6 or more in IF Statements Showing Error

    Started by Sri.n‎, 04-30-2021 01:02 AM
    1 Attachment(s)
    • 5
    • 257
    Sri.n
    04-30-2021, 02:15 AM Go to last post

  27. [SOLVED] Extracting and arranging data

    Started by paradise2sr‎, 04-21-2021 04:03 AM
    9 Attachment(s)
    • 13
    • 536
    paradise2sr
    04-30-2021, 12:48 AM Go to last post

  28. Prevent Workbook opening without a code or another file on the computer.

    Started by John.T‎, 04-30-2021 12:36 AM
    • 1
    • 210
    FDibbins
    04-30-2021, 12:38 AM Go to last post

  29. [SOLVED] Dynamically Count by month and gender

    Started by chaiyya345‎, 04-29-2021 10:34 PM
    1 Attachment(s)
    • 3
    • 194
    Gregb11
    04-29-2021, 11:08 PM Go to last post

  30. Randomly assign an application to 5 reviewers, taking into account Conflicts-of-interest

    Started by MMOKEZ‎, 04-29-2021 09:24 PM
    • 1
    • 230
    Phuocam
    04-29-2021, 09:35 PM Go to last post

  31. adding values from row A to a constant in row B

    Started by azpackrat‎, 04-29-2021 08:24 PM
    • 4
    • 288
    6StringJazzer
    04-29-2021, 09:31 PM Go to last post

  32. vlookup across sheets help needed

    Started by D8THSTAR‎, 04-29-2021 03:21 PM
    3 Attachment(s)
    • 9
    • 365
    FlameRetired
    04-29-2021, 06:46 PM Go to last post

  33. Extract date from string

    Started by acandan21‎, 04-29-2021 02:20 PM
    • 3
    • 236
    Fluff13
    04-29-2021, 04:46 PM Go to last post

  34. [SOLVED] COUNTIF not listed in A2:A79

    Started by jmcole‎, 04-29-2021 01:15 PM
    2 Attachment(s)
    • 7
    • 271
    6StringJazzer
    04-29-2021, 04:28 PM Go to last post

  35. Move all text containing ABC to Cell A1 separated by ,

    Started by rolive‎, 04-29-2021 02:47 PM
    commas
    • 7
    • 270
    Fluff13
    04-29-2021, 03:34 PM Go to last post

  36. Substitute text in a string if it matches a value in a table

    Started by carolinahusker‎, 04-29-2021 01:45 PM
    2 Attachment(s)
    • 3
    • 183
    JohnTopley
    04-29-2021, 02:50 PM Go to last post

  37. [SOLVED] Drop Down with YES choice but Changes to a check Mark

    Started by tacnola‎, 04-29-2021 09:45 AM
    2 Attachment(s)
    • 7
    • 232
    tacnola
    04-29-2021, 02:19 PM Go to last post

  38. Need formula for Bid Bond Calculation

    Started by electricguy57104‎, 04-29-2021 12:50 PM
    bid bond, formula 1 Attachment(s)
    • 5
    • 542
    MrShorty
    04-29-2021, 02:16 PM Go to last post

  39. IF/THEN on Blood Collection Times Post COVID-19 Test Using Date/Time

    Started by Amy EH‎, 04-29-2021 01:51 PM
    date & time calculation, hour calculation, nested formula
    • 1
    • 267
    FlameRetired
    04-29-2021, 02:03 PM Go to last post

  40. [SOLVED] Formula for same value in cell on different sheet

    Started by dodde‎, 04-28-2021 05:18 AM
    1 Attachment(s)
    • 13
    • 424
    dodde
    04-29-2021, 01:51 PM Go to last post

  41. [SOLVED] Need to populate counts from multiple workbooks into main report based on month

    Started by cubangt‎, 04-29-2021 09:41 AM
    5 Attachment(s)
    • 10
    • 292
    cubangt
    04-29-2021, 01:42 PM Go to last post

  42. Two criteria, return "1"

    Started by Calc7827‎, 04-28-2021 05:20 PM
    • 5
    • 243
    etaf
    04-29-2021, 12:39 PM Go to last post

  43. [SOLVED] INDEX and MATCH Formula Error

    Started by VijayJangam‎, 04-12-2021 07:36 AM
    3 Attachment(s)
    • 12
    • 407
    VijayJangam
    04-29-2021, 12:34 PM Go to last post

  44. [SOLVED] Create new sentence after "Good Morning James"

    Started by Howardc1001‎, 04-29-2021 11:18 AM
    1 Attachment(s)
    • 2
    • 335
    Howardc1001
    04-29-2021, 12:03 PM Go to last post

  45. Question [SOLVED] Need a formula to subtract 1 from another cell depending on the text input in another cell

    Started by SoheebHussain‎, 04-29-2021 11:12 AM
    automatically change, change a cell value, dropdown list excel, formula and functions, subtract if 1 Attachment(s)
    • 3
    • 466
    Pete_UK
    04-29-2021, 11:31 AM Go to last post

  46. Pay Scale with bonuses

    Started by raymondcg‎, 04-29-2021 09:42 AM
    1 Attachment(s)
    • 2
    • 207
    raymondcg
    04-29-2021, 11:30 AM Go to last post

  47. Question Average non-continuous cells if not '0'

    Started by g_teacher_1848‎, 04-29-2021 06:27 AM
    average, formula 5 Attachment(s)
    • 12
    • 610
    Pete_UK
    04-29-2021, 11:11 AM Go to last post

  48. Counting values in one column based on the value in another column

    Started by BH1983‎, 04-29-2021 10:50 AM
    1 Attachment(s)
    • 2
    • 202
    BH1983
    04-29-2021, 11:01 AM Go to last post

  49. [SOLVED] A lookup table that varies according to the row of the lookup.

    Started by Osprey2‎, 04-28-2021 10:25 AM
    1 Attachment(s)
    • 6
    • 261
    phatdear
    04-29-2021, 10:50 AM Go to last post

  50. Modify formula and conditional formatting

    Started by GPetcu‎, 04-29-2021 05:43 AM
    2 Attachment(s)
    • 6
    • 228
    kvsrinivasamurthy
    04-29-2021, 10:24 AM Go to last post
+ Post New Thread
Page 500 of 5613 FirstFirst ... 500 ...

Forum Information and Options

Users Browsing this Forum

There are currently 108 users browsing this forum. (9 members & 99 guests)

  1. AliGW,
  2. Czeslaw,
  3. Efendi,
  4. HansDouwe,
  5. kamast95,
  6. miribilist123,
  7. Phuocam,
  8. SjofaaSj,
  9. ulkeora

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