+ Post New Thread
Page 50 of 5611 FirstFirst ... 50 ...
Threads 2451 to 2500 of 280542

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

  1. [SOLVED] If Column is Negative, then -Sumif

    Started by FT00‎, 12-11-2023 11:41 AM
    1 Attachment(s)
    • 4
    • 182
    josephteh
    12-11-2023, 12:03 PM Go to last post

  2. [SOLVED] Help Wanted with Excel Formula for Specific Numbers

    Started by Mxmaarten‎, 12-11-2023 06:56 AM
    6 Attachment(s)
    • 9
    • 211
    AliGW
    12-11-2023, 11:26 AM Go to last post

  3. Need help converting a google sheets formula to excel

    Started by Newtonus_Prime‎, 12-06-2023 12:10 PM
    6 Attachment(s)
    • 7
    • 421
    Newtonus_Prime
    12-11-2023, 10:56 AM Go to last post

  4. Data Analysis Addon - What are the formulas for Regression Analysis to add it manually

    Started by daliye‎, 12-11-2023 08:15 AM
    • 1
    • 116
    MrShorty
    12-11-2023, 10:44 AM Go to last post

  5. [SOLVED] Countifs formula not working.

    Started by NewNow2356‎, 12-11-2023 09:04 AM
    1 Attachment(s)
    • 7
    • 114
    NewNow2356
    12-11-2023, 10:23 AM Go to last post

  6. Exclamation Formula needed for lookup/sync between two sheets in same workbook

    Started by Gregorilla‎, 12-10-2023 01:20 PM
    formula 4 Attachment(s)
    • 9
    • 209
    windknife
    12-11-2023, 09:57 AM Go to last post

  7. Lightbulb Need help with relative distribution on different timeline

    Started by appeniko‎, 12-08-2023 08:08 PM
    1 Attachment(s)
    • 2
    • 192
    appeniko
    12-11-2023, 07:29 AM Go to last post

  8. Lightbulb [SOLVED] Need for formula for to calculate the total time.

    Started by anavarathan‎, 12-11-2023 06:44 AM
    excel fomula, time additions 2 Attachment(s)
    • 6
    • 129
    TMS
    12-11-2023, 07:11 AM Go to last post

  9. extracting and compiling data from a spreadsheet with many blank cells

    Started by KevLearns‎, 12-11-2023 05:05 AM
    4 Attachment(s)
    • 9
    • 156
    AliGW
    12-11-2023, 06:47 AM Go to last post

  10. [SOLVED] Excel formula to extract data from salary sheet to payslip

    Started by sunboy‎, 12-09-2023 04:19 PM
    12 Attachment(s)
    • 20
    • 621
    sunboy
    12-11-2023, 06:45 AM Go to last post

  11. Moved: Need to make this sheet dynamic ,altering a function in a specific cell

    Started by kvemperor‎, 12-09-2023 04:24 AM
    •  
    •  

  12. [SOLVED] Grid Data reference formula.

    Started by Bob1955‎, 12-11-2023 05:28 AM
    1 Attachment(s)
    • 1
    • 269
    AliGW
    12-11-2023, 05:35 AM Go to last post

  13. Any idea for data arrangement?

    Started by okeyla‎, 12-11-2023 02:14 AM
    4 Attachment(s)
    • 4
    • 156
    HansDouwe
    12-11-2023, 05:31 AM Go to last post

  14. Question [SOLVED] Apply Filter function into merged cells

    Started by Hesham121‎, 12-11-2023 04:29 AM
    2 Attachment(s)
    • 12
    • 174
    TMS
    12-11-2023, 05:30 AM Go to last post

  15. [SOLVED] How can i use Filter with UNIQUE but filtering from a list?

    Started by oneblondebrow‎, 12-08-2023 12:53 PM
    1 Attachment(s)
    • 2
    • 132
    AliGW
    12-11-2023, 05:10 AM Go to last post

  16. [SOLVED] Need formula to automatically sum all values within a year

    Started by Tirrazo‎, 12-09-2023 05:55 AM
    4 Attachment(s)
    • 7
    • 210
    Rick Rothstein
    12-11-2023, 02:42 AM Go to last post

  17. [SOLVED] How to add sum formula for various sheets?

    Started by rizwanulhasan‎, 04-08-2023 02:47 PM
    sum formula 4 Attachment(s)
    • 14
    • 377
    rizwanulhasan
    12-11-2023, 02:06 AM Go to last post

  18. if specific text in one cell then return value taken from a different cell

    Started by GaryMN‎, 12-10-2023 06:08 PM
    1 Attachment(s)
    • 4
    • 158
    AliGW
    12-11-2023, 01:52 AM Go to last post

  19. Moved: If statement within INDEX/MATCH

    Started by EJen‎, 12-10-2023 11:58 PM
    •  
    •  

  20. Determine price

    Started by erenbe‎, 12-10-2023 06:05 PM
    calc price 1 Attachment(s)
    • 1
    • 123
    MrShorty
    12-11-2023, 12:04 AM Go to last post

  21. IF formula help

    Started by rhino80‎, 12-10-2023 09:14 PM
    • 1
    • 116
    TMS
    12-10-2023, 09:20 PM Go to last post

  22. Calculate and format date/time

    Started by CorneliaYoder‎, 12-09-2023 04:00 PM
    2 Attachment(s)
    • 11
    • 2,208
    TMS
    12-10-2023, 08:42 PM Go to last post

  23. [SOLVED] Color all the cells in a grid that contain 1, with the color that references text in cell

    Started by BullseyeThor‎, 12-10-2023 06:59 PM
    4 Attachment(s)
    • 11
    • 221
    BullseyeThor
    12-10-2023, 08:12 PM Go to last post

  24. Thumbs up [SOLVED] N/A # issues in Array Formula also need help in IF condition espacially Edate

    Started by Shahmeer‎, 12-10-2023 06:50 AM
    4 Attachment(s)
    • 11
    • 340
    JohnTopley
    12-10-2023, 05:06 PM Go to last post

  25. [SOLVED] Substituting charaters in a text string - Dynamic chord transcribe tool

    Started by obituar‎, 12-09-2023 01:26 PM
    chord, key change, music, transcribing 2 Attachment(s)
    • 4
    • 186
    Glenn Kennedy
    12-10-2023, 02:12 PM Go to last post

  26. Autofull in large increments

    Started by Sanjyn81‎, 12-10-2023 07:44 AM
    • 2
    • 201
    deadlyduck
    12-10-2023, 11:26 AM Go to last post

  27. Sum Weekly and Monthly total

    Started by gotchamed‎, 12-10-2023 09:25 AM
    1 Attachment(s)
    • 9
    • 215
    AliGW
    12-10-2023, 10:45 AM Go to last post

  28. Loop from one row to another based on criteria pop up as input box

    Started by Ciupanezul21‎, 12-09-2023 07:02 PM
    1 Attachment(s)
    • 1
    • 174
    AliGW
    12-10-2023, 10:01 AM Go to last post

  29. Converting (h):mm:ss to minutes

    Started by ACrossley1‎, 12-10-2023 07:06 AM
    • 1
    • 101
    Phuocam
    12-10-2023, 07:15 AM Go to last post

  30. Coupon Claims Date to be next date with the help of formula

    Started by Shahmeer‎, 12-05-2023 09:56 AM
    24 Attachment(s)
    • 49
    • 684
    AliGW
    12-10-2023, 07:05 AM Go to last post

  31. [SOLVED] Find Max Value and 4th Largest Number within subset of data

    Started by fpgary‎, 12-09-2023 04:57 PM
    1 Attachment(s)
    • 5
    • 189
    TMS
    12-10-2023, 04:28 AM Go to last post

  32. Find total occurrence of 5 consecutive same value

    Started by ExcelGuru12‎, 12-09-2023 01:35 PM
    1 Attachment(s)
    • 3
    • 229
    Gregb11
    12-09-2023, 11:21 PM Go to last post

  33. Formula Highlights on Diff Sheet?

    Started by NewYears1978‎, 12-04-2023 01:20 PM
    • 9
    • 295
    6StringJazzer
    12-09-2023, 11:07 PM Go to last post

  34. [SOLVED] Help with ignoring empty/blank cells

    Started by BigDave83‎, 12-09-2023 04:35 PM
    1 Attachment(s)
    • 3
    • 145
    alansidman
    12-09-2023, 10:57 PM Go to last post

  35. [SOLVED] Need consolidated Total duration of the training hours spent by each employee

    Started by vijavad‎, 10-30-2023 09:06 AM
    7 Attachment(s)
    • 18
    • 577
    Czeslaw
    12-09-2023, 02:45 PM Go to last post

  36. Question [SOLVED] MAX function to increment numbers on estimating sheet

    Started by 3lusive‎, 12-09-2023 07:52 AM
    2 Attachment(s)
    • 6
    • 238
    3lusive
    12-09-2023, 12:01 PM Go to last post

  37. Need help with combining percentages and linking names

    Started by Jelly820‎, 12-08-2023 06:27 PM
    3 Attachment(s)
    • 5
    • 255
    Gregb11
    12-09-2023, 11:27 AM Go to last post

  38. [SOLVED] Formula for plus and minus specific values

    Started by keshavtale‎, 12-09-2023 07:59 AM
    2 Attachment(s)
    • 2
    • 110
    keshavtale
    12-09-2023, 10:08 AM Go to last post

  39. [SOLVED] Calculate number of days for a certain year within a period

    Started by teddy_bear‎, 12-09-2023 05:18 AM
    4 Attachment(s)
    • 7
    • 208
    HansDouwe
    12-09-2023, 09:24 AM Go to last post

  40. VLOOKUP function is not working properly on percentages

    Started by Arinjay Jain‎, 12-09-2023 08:29 AM
    vlookup 2 Attachment(s)
    • 3
    • 125
    Pepe Le Mokko
    12-09-2023, 08:58 AM Go to last post

  41. [SOLVED] Including leading zeros in number format cells

    Started by mbender‎, 12-09-2023 05:37 AM
    2 Attachment(s)
    • 8
    • 164
    Glenn Kennedy
    12-09-2023, 06:19 AM Go to last post

  42. [SOLVED] SORT Data from largest to smallest

    Started by Etax‎, 12-09-2023 03:18 AM
    1 Attachment(s)
    • 18
    • 201
    HansDouwe
    12-09-2023, 04:04 AM Go to last post

  43. [SOLVED] Difficult XLOOKUP question

    Started by Tricks420‎, 12-06-2023 05:28 PM
    7 Attachment(s)
    • 11
    • 361
    AliGW
    12-09-2023, 03:12 AM Go to last post

  44. return name from a list by certain country and number of employees

    Started by NicBKK‎, 12-08-2023 11:30 PM
    2 Attachment(s)
    • 2
    • 152
    HansDouwe
    12-09-2023, 12:37 AM Go to last post

  45. if formula

    Started by carrollm‎, 12-08-2023 07:20 PM
    formula if 1 Attachment(s)
    • 1
    • 135
    TMS
    12-08-2023, 08:31 PM Go to last post

  46. Moved: Help referencing CLOSED workbook:

    Started by BastImret‎, 12-08-2023 01:02 AM
    •  
    •  

  47. Question Due this week?

    Started by anich‎, 12-08-2023 03:41 PM
    • 1
    • 151
    JohnTopley
    12-08-2023, 04:43 PM Go to last post

  48. [SOLVED] PEMDAS Practice

    Started by etane‎, 12-08-2023 02:12 AM
    pemdas 3 Attachment(s)
    • 14
    • 321
    etane
    12-08-2023, 04:14 PM Go to last post

  49. [SOLVED] Data lands on a weekend, how to ADD it to cell before or after.

    Started by Tricks420‎, 12-08-2023 12:29 PM
    1 Attachment(s)
    • 5
    • 134
    AliGW
    12-08-2023, 01:24 PM Go to last post

  50. Lookup with Criteria

    Started by slimseidl‎, 12-08-2023 12:42 PM
    1 Attachment(s)
    • 1
    • 129
    AliGW
    12-08-2023, 01:09 PM Go to last post
+ Post New Thread
Page 50 of 5611 FirstFirst ... 50 ...

Forum Information and Options

Users Browsing this Forum

There are currently 90 users browsing this forum. (7 members & 83 guests)

  1. BE_receiving,
  2. Edward Hyde,
  3. Estevaoba,
  4. Jacc,
  5. LeapyUK,
  6. lilsnoop,
  7. sanda_dennisp

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