+ Post New Thread
Page 550 of 5618 FirstFirst ... 550 ...
Threads 27451 to 27500 of 280856

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

  1. [SOLVED] Rank, select, conditional format

    Started by thedunna‎, 02-15-2021 12:26 PM
    12 Attachment(s)
    • 21
    • 664
    AliGW
    02-16-2021, 05:24 PM Go to last post

  2. Exclamation Checking off items on one sheet when selected on another

    Started by ryley.o‎, 02-16-2021 12:03 PM
    dropdown, format, lists, multiple 3 Attachment(s)
    • 14
    • 912
    ChemistB
    02-16-2021, 04:41 PM Go to last post

  3. Find a 2nd set of data in a string

    Started by ms.fb‎, 02-16-2021 02:43 PM
    • 1
    • 306
    Glenn Kennedy
    02-16-2021, 02:53 PM Go to last post

  4. Code problems

    Started by donkey_uk‎, 02-16-2021 12:43 PM
    • 2
    • 212
    AliGW
    02-16-2021, 02:32 PM Go to last post

  5. [SOLVED] Something is wrong in this index calculation. HOW TO CORRECT THIS ?

    Started by omega0010‎, 02-11-2021 11:18 PM
    3 Attachment(s)
    • 6
    • 356
    omega0010
    02-16-2021, 02:24 PM Go to last post

  6. dfsdffadsfasdfadsf

    Started by gr8whthunter76‎, 02-16-2021 01:16 PM
    • 6
    • 248
    AliGW
    02-16-2021, 02:13 PM Go to last post

  7. How to Calculate % based on number of Months is less than 12

    Started by Stephy2741‎, 02-05-2021 10:53 AM
    3 Attachment(s)
    • 6
    • 625
    JeteMc
    02-16-2021, 01:53 PM Go to last post

  8. Return a value based on multiple date ranges

    Started by Sherene.D‎, 02-12-2021 10:18 AM
    2 Attachment(s)
    • 7
    • 312
    Glenn Kennedy
    02-16-2021, 12:18 PM Go to last post

  9. [SOLVED] VLookup producing incorrect table

    Started by Marvo‎, 02-16-2021 07:35 AM
    2 Attachment(s)
    • 29
    • 594
    AliGW
    02-16-2021, 12:02 PM Go to last post

  10. [SOLVED] Fun With Multiple Criteria Lookup and Merged Cells

    Started by tgallag1‎, 02-15-2021 06:15 PM
    1 Attachment(s)
    • 3
    • 360
    ChemistB
    02-16-2021, 10:12 AM Go to last post

  11. Help with Filter Function from a dynamic data set with formulas

    Started by Subidai‎, 02-15-2021 06:12 PM
    2 Attachment(s)
    • 5
    • 385
    Fluff13
    02-16-2021, 09:54 AM Go to last post

  12. Grouping Data

    Started by Rurouini‎, 02-15-2021 12:37 AM
    1 Attachment(s)
    • 2
    • 292
    Pepe Le Mokko
    02-16-2021, 09:21 AM Go to last post

  13. How to use vlookup on transposed data?

    Started by mss90‎, 02-16-2021 07:31 AM
    2 Attachment(s)
    • 7
    • 322
    Glenn Kennedy
    02-16-2021, 08:46 AM Go to last post

  14. [SOLVED] Position parity ranking

    Started by Berna11‎, 02-16-2021 07:55 AM
    2 Attachment(s)
    • 2
    • 222
    Berna11
    02-16-2021, 08:16 AM Go to last post

  15. Smile [SOLVED] Extract Text from Description

    Started by GemBox‎, 02-16-2021 06:29 AM
    1 Attachment(s)
    • 6
    • 325
    Pete_UK
    02-16-2021, 07:07 AM Go to last post

  16. [SOLVED] SUMPRODUCT Need 4 columns

    Started by Berna11‎, 02-16-2021 06:01 AM
    1 Attachment(s)
    • 3
    • 229
    Pete_UK
    02-16-2021, 06:22 AM Go to last post

  17. Post [SOLVED] Descriptive statistics

    Started by mermel‎, 02-15-2021 12:27 PM
    1 Attachment(s)
    • 3
    • 349
    mermel
    02-16-2021, 06:08 AM Go to last post

  18. find max value in column to match exact number and add one

    Started by alexanderears‎, 02-15-2021 07:00 PM
    3 Attachment(s)
    • 10
    • 363
    kvsrinivasamurthy
    02-16-2021, 06:05 AM Go to last post

  19. Question Revenue Based Tiered Commission Formula (?)

    Started by LuluSylvana‎, 02-13-2021 01:47 PM
    commission revenue 4 Attachment(s)
    • 7
    • 334
    Glenn Kennedy
    02-16-2021, 05:59 AM Go to last post

  20. [SOLVED] Conditional Formatting from other cell not working if value from left apply to cell right

    Started by chaiyya345‎, 02-16-2021 04:28 AM
    2 Attachment(s)
    • 2
    • 307
    chaiyya345
    02-16-2021, 05:21 AM Go to last post

  21. Post Single Formula Conditional Formatting for 3 Criteria

    Started by Robert5042‎, 02-15-2021 02:37 PM
    cell color, columns, conditional formatting, dates, formula 8 Attachment(s)
    • 7
    • 673
    AliGW
    02-16-2021, 04:49 AM Go to last post

  22. Counting unique dates with criteria

    Started by tisko‎, 02-12-2021 10:37 AM
    1 Attachment(s)
    • 2
    • 322
    tisko
    02-16-2021, 04:41 AM Go to last post

  23. [SOLVED] Conditional formatting with protection

    Started by jimmiboy‎, 02-16-2021 03:19 AM
    1 Attachment(s)
    • 0
    • 231
    jimmiboy
    02-16-2021, 03:19 AM Go to last post

  24. [SOLVED] Find minimum value in 2 columns based on multiple criteria

    Started by thedunna‎, 02-15-2021 09:03 PM
    1 Attachment(s)
    • 2
    • 277
    AliGW
    02-16-2021, 02:19 AM Go to last post

  25. Post Help with Consecutive 5 Digits Number Extract Function

    Started by pomamo‎, 02-16-2021 01:50 AM
    extract numbers 1 Attachment(s)
    • 1
    • 290
    FDibbins
    02-16-2021, 02:14 AM Go to last post

  26. [SOLVED] Adding cells containing Tick only

    Started by VisionSmart‎, 02-16-2021 01:21 AM
    1 Attachment(s)
    • 3
    • 178
    FDibbins
    02-16-2021, 02:13 AM Go to last post

  27. [SOLVED] Dynamic Named Range and drop down list

    Started by VisionSmart‎, 12-19-2020 01:01 AM
    4 Attachment(s)
    • 5
    • 491
    VisionSmart
    02-16-2021, 01:27 AM Go to last post

  28. [SOLVED] Nested IFs performance Matrix

    Started by VisionSmart‎, 01-29-2021 08:46 PM
    4 Attachment(s)
    • 10
    • 587
    VisionSmart
    02-16-2021, 01:24 AM Go to last post

  29. [SOLVED] Count Unique Values on concurrent dates based on a criteria

    Started by casper_01‎, 02-13-2021 06:03 PM
    3 Attachment(s)
    • 7
    • 491
    kvsrinivasamurthy
    02-15-2021, 11:07 PM Go to last post

  30. Auto Increasement Not Working

    Started by cyliyu‎, 02-06-2021 06:22 AM
    3 Attachment(s)
    • 10
    • 451
    cyliyu
    02-15-2021, 11:00 PM Go to last post

  31. [SOLVED] Calculate superannuation to a maximum pay amount

    Started by Skumby‎, 02-15-2021 08:42 PM
    • 0
    • 591
    Skumby
    02-15-2021, 08:42 PM Go to last post

  32. [SOLVED] help with INDEX MATCH pulling correct data

    Started by allgoodthings‎, 02-15-2021 07:48 PM
    1 Attachment(s)
    • 1
    • 215
    korekurd
    02-15-2021, 08:30 PM Go to last post

  33. pulling missing rows from different sheet

    Started by tenerifa6‎, 02-15-2021 01:38 PM
    2 Attachment(s)
    • 3
    • 229
    Glenn Kennedy
    02-15-2021, 03:00 PM Go to last post

  34. [SOLVED] help with VLOOKUP that matches multiple criteria

    Started by allgoodthings‎, 02-15-2021 10:48 AM
    3 Attachment(s)
    • 8
    • 406
    Glenn Kennedy
    02-15-2021, 02:13 PM Go to last post

  35. [SOLVED] Discounted cash flow formula giving #REF!

    Started by Heyy‎, 02-15-2021 11:28 AM
    • 4
    • 296
    AliGW
    02-15-2021, 12:23 PM Go to last post

  36. [SOLVED] Copy new row to a second page

    Started by fatfish1969‎, 01-23-2021 02:39 PM
    2 Attachment(s)
    • 9
    • 609
    AliGW
    02-15-2021, 12:07 PM Go to last post

  37. [SOLVED] Trying to alphabetically sort data for literary review references in Excel

    Started by JPR101‎, 02-09-2021 12:54 PM
    7 Attachment(s)
    • 16
    • 422
    AliGW
    02-15-2021, 12:05 PM Go to last post

  38. How do I use If with Match to fill a cell automatically?

    Started by NotQuiteThere‎, 02-15-2021 07:54 AM
    2 Attachment(s)
    • 5
    • 273
    NotQuiteThere
    02-15-2021, 11:33 AM Go to last post

  39. Question [SOLVED] Format cell colour based on time interval expressed as text

    Started by emmr‎, 02-15-2021 08:47 AM
    3 Attachment(s)
    • 8
    • 295
    emmr
    02-15-2021, 10:59 AM Go to last post

  40. SUM Function arguments

    Started by jakster‎, 02-15-2021 09:49 AM
    arguments, sum, syntax
    • 8
    • 554
    jakster
    02-15-2021, 10:58 AM Go to last post

  41. Question [SOLVED] Update Data Validation for multiple cells

    Started by Jesstin‎, 02-15-2021 10:49 AM
    • 0
    • 882
    Jesstin
    02-15-2021, 10:49 AM Go to last post

  42. Autofill with Letters as a Suffix to a fixed Number

    Started by Dogwap‎, 02-11-2021 03:54 PM
    auto fill
    • 5
    • 578
    Dogwap
    02-15-2021, 10:40 AM Go to last post

  43. [SOLVED] Nested IF OR AND

    Started by Mark-NY‎, 02-14-2021 05:41 PM
    nested if or and
    • 8
    • 385
    TMS
    02-15-2021, 10:17 AM Go to last post

  44. [SOLVED] SOLVED***Sort and rearrange if 1 number is higher in certain rows

    Started by king10001‎, 02-15-2021 10:02 AM
    2 Attachment(s)
    • 1
    • 174
    Glenn Kennedy
    02-15-2021, 10:07 AM Go to last post

  45. Add or subtract data IF drop-down list says x or y

    Started by mechanimichael‎, 02-13-2021 01:14 PM
    • 6
    • 486
    AliGW
    02-15-2021, 10:03 AM Go to last post

  46. [SOLVED] reference to sheets without using sheet names

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 40
    • 12,114
    FoxBox
    02-15-2021, 09:36 AM Go to last post

  47. Display cells when you hover over a cell

    Started by mania112‎, 02-14-2021 10:51 AM
    2 Attachment(s)
    • 8
    • 6,774
    Richard Buttrey
    02-15-2021, 08:31 AM Go to last post

  48. [SOLVED] Extract a range based on a value

    Started by mvatan‎, 02-15-2021 01:54 AM
    5 Attachment(s)
    • 4
    • 361
    Glenn Kennedy
    02-15-2021, 08:04 AM Go to last post

  49. [SOLVED] Calculation with multiple criteria- CAP Amount, Min. Amount etc.

    Started by Shareez Saleem‎, 02-11-2021 01:52 AM
    2 Attachment(s)
    • 7
    • 415
    Glenn Kennedy
    02-15-2021, 07:59 AM Go to last post

  50. formula to check correct data

    Started by Belinda001‎, 02-15-2021 04:58 AM
    2 Attachment(s)
    • 6
    • 395
    torachan
    02-15-2021, 05:57 AM Go to last post
+ Post New Thread
Page 550 of 5618 FirstFirst ... 550 ...

Forum Information and Options

Users Browsing this Forum

There are currently 80 users browsing this forum. (4 members & 76 guests)

  1. etaf,
  2. sbvaram,
  3. varbergt,
  4. zbor

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