+ Post New Thread
Page 4953 of 5615 FirstFirst ... 4953 ...
Threads 247601 to 247650 of 280701

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

  1. Formula needed for payment scenarios

    Started by successlee‎, 09-16-2015 01:25 AM
    1 Attachment(s)
    • 3
    • 451
    JeteMc
    09-26-2015, 05:53 PM Go to last post

  2. Multiple Countifs in Multiple Sheets

    Started by suchanekeduard‎, 05-25-2021 05:50 AM
    1 Attachment(s)
    • 2
    • 202
    alansidman
    05-25-2021, 05:56 AM Go to last post

  3. [SOLVED] Countif by using a word from the string

    Started by suchetherrah‎, 11-09-2017 12:54 AM
    • 2
    • 330
    suchetherrah
    11-09-2017, 03:57 AM Go to last post

  4. [SOLVED] Extract results from duplicate records to the unique record for statistics

    Started by suchetherrah‎, 10-28-2016 01:48 AM
    1 Attachment(s)
    • 2
    • 451
    suchetherrah
    10-28-2016, 03:46 AM Go to last post

  5. [SOLVED] Find Hostname and Application from a list of IP address from Merged Cell

    Started by suchetherrah‎, 12-07-2016 10:06 AM
    1 Attachment(s)
    • 7
    • 806
    FlameRetired
    12-16-2016, 11:57 AM Go to last post

  6. Sort Data using Formulas

    Started by suchetherrah‎, 04-22-2017 08:13 AM
    6 Attachment(s)
    • 7
    • 456
    JeteMc
    04-24-2017, 10:30 AM Go to last post

  7. [SOLVED] Extract first 3 strings in 3 different cells

    Started by suchetherrah‎, 04-23-2017 11:57 AM
    3 Attachment(s)
    • 17
    • 645
    suchetherrah
    04-24-2017, 08:45 AM Go to last post

  8. [SOLVED] Sort in Alphabetic order for multiple columns

    Started by suchetherrah‎, 04-23-2017 12:27 PM
    3 Attachment(s)
    • 5
    • 324
    suchetherrah
    04-24-2017, 01:28 AM Go to last post

  9. Count consecutive more than 3 days absent in a month/year exclude Sat/Sun/PubHol

    Started by suchetherrah‎, 04-27-2017 12:31 AM
    3 Attachment(s)
    • 4
    • 1,814
    AliGW
    04-30-2017, 12:51 PM Go to last post

  10. Count number of consecutive more than 3 days absent in a month

    Started by suchetherrah‎, 04-30-2017 12:36 PM
    1 Attachment(s)
    • 2
    • 410
    AliGW
    04-30-2017, 12:50 PM Go to last post

  11. Return 1st occurrence of IP address and Location

    Started by suchetherrah‎, 05-14-2017 02:26 AM
    3 Attachment(s)
    • 8
    • 701
    JohnTopley
    05-14-2017, 06:36 AM Go to last post

  12. [SOLVED] Match Hostname to find data from multiple worksheets

    Started by suchetherrah‎, 05-14-2017 04:10 AM
    7 Attachment(s)
    • 10
    • 868
    suchetherrah
    05-14-2017, 12:37 PM Go to last post

  13. [SOLVED] Convert date and time format using formula

    Started by suchetherrah‎, 09-11-2017 05:19 AM
    • 2
    • 277
    suchetherrah
    09-13-2017, 03:43 PM Go to last post

  14. Extract name from the string

    Started by suchetherrah‎, 09-13-2017 04:13 PM
    • 4
    • 375
    shukla.ankur281190
    09-18-2017, 03:39 AM Go to last post

  15. [SOLVED] Multiple nested IF/and to show condition Met or Not Met

    Started by suchetherrah‎, 09-17-2017 02:48 PM
    2 Attachment(s)
    • 7
    • 1,041
    JeteMc
    09-19-2017, 07:54 PM Go to last post

  16. [SOLVED] Add additional Data Validation for selection in INDIRECT formulas

    Started by suchetherrah‎, 08-10-2016 12:06 AM
    2 Attachment(s)
    • 5
    • 681
    Glenn Kennedy
    08-20-2016, 10:49 AM Go to last post

  17. [SOLVED] Convert Exceptional Date to meaningful date format

    Started by suchetherrah‎, 01-17-2018 03:16 PM
    3 Attachment(s)
    • 12
    • 646
    Aardigspook
    06-27-2018, 04:13 PM Go to last post

  18. [SOLVED] Identify 1 IP address from a cell with multiple IPs match against legend of IP segments

    Started by suchetherrah‎, 06-26-2018 11:05 AM
    2 Attachment(s)
    • 3
    • 460
    jason.b75
    06-27-2018, 11:52 AM Go to last post

  19. [SOLVED] Duration with 00:00 not calculating correctly

    Started by suchetherrah‎, 08-15-2018 02:53 AM
    1 Attachment(s)
    • 4
    • 298
    joeu2004
    08-20-2018, 03:43 PM Go to last post

  20. Extract rows of string identified as "Subject...." from multiple TXT files to 1 excel file

    Started by suchetherrah‎, 09-29-2018 04:50 PM
    3 Attachment(s)
    • 1
    • 315
    suchetherrah
    09-30-2018, 12:42 PM Go to last post

  21. Leave Tracker user Monthly Scroll Bar

    Started by suchetherrah‎, 01-03-2019 03:46 AM
    1 Attachment(s)
    • 2
    • 459
    avk
    01-08-2019, 02:01 AM Go to last post

  22. [SOLVED] Convert Formula which has time value to text value

    Started by suchetherrah‎, 01-24-2019 12:07 PM
    1 Attachment(s)
    • 5
    • 295
    FDibbins
    03-16-2019, 02:23 AM Go to last post

  23. [SOLVED] Formula to find percentage with value when last day of the month is dynamic

    Started by suchetherrah‎, 11-25-2019 12:16 AM
    • 2
    • 255
    suchetherrah
    11-26-2019, 12:19 AM Go to last post

  24. [SOLVED] Identify Hostname by finding from a string of IP address in a Cell

    Started by suchetherrah‎, 06-06-2023 11:40 PM
    3 Attachment(s)
    • 7
    • 250
    TMS
    06-07-2023, 11:52 PM Go to last post

  25. [SOLVED] Split data which uses ; from 1 cell to multiple row

    Started by suchetherrah‎, 05-23-2023 05:03 AM
    2 Attachment(s)
    • 7
    • 263
    sandy666
    05-24-2023, 10:24 PM Go to last post

  26. [SOLVED] Split the Range of IP address into rows using the last digit

    Started by suchetherrah‎, 05-25-2023 11:21 AM
    3 Attachment(s)
    • 8
    • 251
    sandy666
    05-26-2023, 10:31 PM Go to last post

  27. [SOLVED] Find out which Team did not attend for 3 consecutive days

    Started by suchetherrah‎, 10-22-2015 03:18 AM
    3 Attachment(s)
    • 4
    • 558
    Glenn Kennedy
    10-22-2015, 12:01 PM Go to last post

  28. [SOLVED] Remove strings only those with version numbers from end of a string

    Started by suchetherrah‎, 09-03-2015 12:17 AM
    2 Attachment(s)
    • 8
    • 1,122
    suchetherrah
    09-04-2015, 02:34 AM Go to last post

  29. [SOLVED] Search and count a word (*delay*) from 3rd Column with multiple criteria from row/column

    Started by suchetherrah‎, 05-22-2015 09:34 PM
    2 Attachment(s)
    • 4
    • 525
    suchetherrah
    05-27-2015, 06:00 PM Go to last post

  30. [SOLVED] When choose a name, it should give me a list of systems involved (match row and Column)

    Started by suchetherrah‎, 05-27-2015 11:23 PM
    3 Attachment(s)
    • 11
    • 699
    jhren
    06-03-2015, 03:22 PM Go to last post

  31. Extract Unique List fr specifc columns for all systems exclude spaces and sort dynamically

    Started by suchetherrah‎, 06-03-2015 01:33 PM
    1 Attachment(s)
    • 0
    • 628
    suchetherrah
    06-03-2015, 01:33 PM Go to last post

  32. Not counting the total records for Aging for greater or less than 1 hour

    Started by suchetherrah‎, 06-04-2015 11:12 AM
    2 Attachment(s)
    • 7
    • 817
    suchetherrah
    06-25-2015, 10:23 AM Go to last post

  33. [SOLVED] List unique values from 2 columns and find out Longest and Shortest Duration

    Started by suchetherrah‎, 06-25-2015 09:57 AM
    3 Attachment(s)
    • 6
    • 798
    suchetherrah
    07-13-2015, 07:52 AM Go to last post

  34. [SOLVED] When Select a summary group, it should display all sub-groups automatically

    Started by suchetherrah‎, 07-13-2015 08:32 AM
    5 Attachment(s)
    • 14
    • 795
    oeldere
    08-26-2015, 05:07 AM Go to last post

  35. [SOLVED] Conditional Formating - show "1" for Blank and any keywords which doesn't show in text

    Started by suchetherrah‎, 09-09-2015 08:14 AM
    • 4
    • 612
    suchetherrah
    09-15-2015, 07:28 AM Go to last post

  36. [SOLVED] Extract 5th string onwards but exclude 6th string onwards if found a specificlist of words

    Started by suchetherrah‎, 01-14-2016 04:26 AM
    2 Attachment(s)
    • 10
    • 1,313
    suchetherrah
    03-07-2016, 03:48 AM Go to last post

  37. Highlight Conditional Formating for more than 3 continous days only in tabular format

    Started by suchetherrah‎, 10-29-2015 02:20 AM
    2 Attachment(s)
    • 7
    • 732
    suchetherrah
    11-19-2015, 11:29 PM Go to last post

  38. [SOLVED] Sum data using index/match by each month and by name

    Started by suchetherrah‎, 09-17-2015 10:32 AM
    3 Attachment(s)
    • 6
    • 807
    FlameRetired
    09-18-2015, 03:10 PM Go to last post

  39. [SOLVED] Extract a word starts with a list of characters from a string

    Started by suchetherrah‎, 10-17-2016 03:02 AM
    3 Attachment(s)
    • 13
    • 846
    suchetherrah
    11-03-2016, 09:18 AM Go to last post

  40. [SOLVED] Conditional formating with 3 different rules applied

    Started by suchetherrah‎, 10-29-2015 09:08 AM
    11 Attachment(s)
    • 26
    • 1,712
    kvsrinivasamurthy
    12-04-2015, 04:23 AM Go to last post

  41. [SOLVED] Flag if the system falls between the date range

    Started by suchetherrah‎, 11-16-2015 02:04 PM
    2 Attachment(s)
    • 6
    • 435
    suchetherrah
    11-17-2015, 12:45 AM Go to last post

  42. [SOLVED] Extract Unique List selected by month/year and Location which has 2 different files

    Started by suchetherrah‎, 11-19-2015 02:22 PM
    2 Attachment(s)
    • 3
    • 385
    Glenn Kennedy
    11-20-2015, 04:52 AM Go to last post

  43. Display comments when highlight the number based on 3 criterias

    Started by suchetherrah‎, 11-20-2015 12:28 AM
    • 3
    • 410
    suchetherrah
    11-24-2015, 07:35 AM Go to last post

  44. [SOLVED] Extract 2 corresponding fields by Date/Month/Year selection

    Started by suchetherrah‎, 11-24-2015 08:56 AM
    1 Attachment(s)
    • 9
    • 999
    suchetherrah
    12-01-2015, 08:31 AM Go to last post

  45. Identify and extract parent record from the raw data

    Started by suchetherrah‎, 12-07-2015 04:29 AM
    • 4
    • 634
    suchetherrah
    12-08-2015, 09:01 PM Go to last post

  46. Identify parent record using IF function to combine the scenarios

    Started by suchetherrah‎, 12-08-2015 09:18 PM
    3 Attachment(s)
    • 8
    • 566
    suchetherrah
    12-09-2015, 04:07 AM Go to last post

  47. [SOLVED] Extract a row of record which identifies a value

    Started by suchetherrah‎, 12-21-2015 07:06 AM
    4 Attachment(s)
    • 4
    • 805
    suchetherrah
    01-07-2016, 12:08 AM Go to last post

  48. [SOLVED] Populate Name and Date for one status only from a list of different status

    Started by suchetherrah‎, 12-23-2015 06:13 AM
    1 Attachment(s)
    • 6
    • 638
    Tony Valko
    12-30-2015, 07:31 AM Go to last post

  49. Extract data for "failed" status only with unique application by month

    Started by suchetherrah‎, 01-15-2016 06:52 AM
    1 Attachment(s)
    • 0
    • 429
    suchetherrah
    01-15-2016, 06:52 AM Go to last post

  50. Convert formula to values and wrap text automatically

    Started by suchetherrah‎, 06-30-2016 11:25 PM
    1 Attachment(s)
    • 4
    • 730
    suchetherrah
    08-09-2016, 11:42 PM Go to last post
+ Post New Thread
Page 4953 of 5615 FirstFirst ... 4953 ...

Forum Information and Options

Users Browsing this Forum

There are currently 66 users browsing this forum. (7 members & 59 guests)

  1. alansidman,
  2. Lafsen,
  3. ohitsadonkey,
  4. RaulSerg,
  5. windknife

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