+ Post New Thread
Page 1 of 2 1
Threads 1 to 50 of 88

Forum: Excel Tips

  1. Subset Sum Problem

    Started by smuzoen‎, 07-05-2012 09:55 AM
    1 Attachment(s)
    • 0
    • 1,674
    smuzoen
    07-05-2012, 09:55 AM Go to last post

  2. adding two cells trick

    Started by martindwilson‎, 07-05-2012 08:50 AM
    • 3
    • 1,602
    vandan_tanna
    07-05-2012, 02:47 PM Go to last post

  3. Find Range Function

    Started by smuzoen‎, 07-05-2012 09:43 AM
    • 3
    • 1,367
    smuzoen
    07-05-2012, 07:07 PM Go to last post

  4. how to figure out that worksheet is set to Manual Calculation mode

    Started by icestationzbra‎, 07-08-2012 04:03 PM
    1 Attachment(s)
    • 7
    • 1,997
    martindwilson
    07-09-2012, 05:42 AM Go to last post

  5. Some Handy Personal Macros: Clear-Duplicates-Below-Selection

    Started by GeneralDisarray‎, 07-10-2012 02:20 PM
    • 0
    • 974
    GeneralDisarray
    07-10-2012, 02:20 PM Go to last post

  6. Some handy Personal Macros: Text version of the Large Function

    Started by GeneralDisarray‎, 07-10-2012 02:05 PM
    1 Attachment(s)
    • 2
    • 1,541
    GeneralDisarray
    07-10-2012, 03:56 PM Go to last post

  7. calendar with tasks for each day

    Started by icestationzbra‎, 07-10-2012 07:39 PM
    • 0
    • 1,163
    icestationzbra
    07-10-2012, 07:39 PM Go to last post

  8. Lookup & return Multiple Results

    Started by benishiryo‎, 07-10-2012 10:34 AM
    1 Attachment(s)
    • 2
    • 2,369
    benishiryo
    07-11-2012, 10:11 AM Go to last post

  9. Personal Notes or Hidden Text in a Excel Formula

    Started by dilipandey‎, 07-03-2012 02:35 PM
    hidden notes in formula 1 Attachment(s)
    • 13
    • 5,026
    dilipandey
    07-12-2012, 01:46 PM Go to last post

  10. Change Column/Row Header Styles

    Started by vlady‎, 07-12-2012 10:07 PM
    • 0
    • 994
    vlady
    07-12-2012, 10:07 PM Go to last post

  11. Post Excel Scheduler Process to Run the Excel WorkBook Macro

    Started by ravisankarbabuk‎, 07-13-2012 03:05 AM
    applicaion ontime, applicayion.ontime, running macro, schedule macro 5 Attachment(s)
    • 0
    • 1,138
    ravisankarbabuk
    07-13-2012, 03:05 AM Go to last post

  12. Using F2 to edit ranges in Name Manager and Conditional Formatting

    Started by TMS‎, 07-13-2012 06:01 AM
    conditional formatting, edit, name manager, using f2
    • 0
    • 1,423
    TMS
    07-13-2012, 06:01 AM Go to last post

  13. "Mirror" of filtered data, using formulas.

    Started by Fotis1991‎, 07-09-2012 10:31 AM
    2 Attachment(s)
    • 11
    • 12,342
    apla
    07-13-2012, 12:42 PM Go to last post

  14. 'Simple Gantt' - Small, feature rich gantt chart requiring minimal formatting - finally!

    Started by mikeem‎, 07-13-2012 06:40 PM
    2 Attachment(s)
    • 0
    • 2,461
    mikeem
    07-13-2012, 06:40 PM Go to last post

  15. how to extract a list of all the files and folders within a Windows OS folder onto Excel

    Started by icestationzbra‎, 07-13-2012 10:51 PM
    • 0
    • 2,342
    icestationzbra
    07-13-2012, 10:51 PM Go to last post

  16. Lightbulb Seat position finder, Indian Railway.

    Started by sreejith K K‎, 07-14-2012 09:29 AM
    2 Attachment(s)
    • 6
    • 5,194
    sreejith K K
    07-15-2012, 02:45 PM Go to last post

  17. Count filtered cells using SUBTOTAL

    Started by Russell Dawson‎, 07-13-2012 06:22 AM
    filter data, subtotal function 1 Attachment(s)
    • 2
    • 2,999
    sreejith K K
    07-15-2012, 03:39 PM Go to last post

  18. How to display an image picture in a thread.

    Started by MarvinP‎, 07-14-2012 12:01 PM
    2 Attachment(s)
    • 7
    • 2,119
    ChemistB
    07-16-2012, 01:17 PM Go to last post

  19. mirror

    Started by martindwilson‎, 07-14-2012 09:14 AM
    • 6
    • 3,033
    martindwilson
    07-17-2012, 05:16 PM Go to last post

  20. let excel talk to you

    Started by martindwilson‎, 07-12-2012 07:30 PM
    1 Attachment(s)
    • 10
    • 3,614
    Paul
    07-17-2012, 05:23 PM Go to last post

  21. Cool Tick Box&Dropdowning box cooperation with EBIT datas

    Started by gazteknokrat‎, 07-18-2012 05:02 AM
    drop down box, ebitda, refresh/hide/unhide all, tick boxes
    • 0
    • 1,292
    gazteknokrat
    07-18-2012, 05:02 AM Go to last post

  22. Some handy Personal Macros: Return Column Letter for column number.

    Started by GeneralDisarray‎, 07-10-2012 02:28 PM
    • 4
    • 2,259
    jindon
    07-18-2012, 08:54 PM Go to last post

  23. Explanatory Formulas

    Started by Steffen Thomsen‎, 07-19-2012 08:39 AM
    1 Attachment(s)
    • 4
    • 1,900
    Steffen Thomsen
    07-19-2012, 10:03 AM Go to last post

  24. Fast switching between large number of worksheets

    Started by dilipandey‎, 07-20-2012 01:31 AM
    choose sheet, selecting sheet, selecting worksheet 1 Attachment(s)
    • 0
    • 2,342
    dilipandey
    07-20-2012, 01:31 AM Go to last post

  25. Excel Calendar + Memo

    Started by SCLai‎, 07-24-2012 02:30 AM
    1 Attachment(s)
    • 0
    • 2,529
    SCLai
    07-24-2012, 02:30 AM Go to last post

  26. Importing JSON Data into Excel

    Started by Kyle123‎, 07-23-2012 06:32 AM
    • 1
    • 19,708
    Kyle123
    07-25-2012, 08:47 AM Go to last post

  27. Change the Task's progress bar colours by clicking it

    Started by Kelshaer‎, 07-25-2012 02:29 PM
    1 Attachment(s)
    • 2
    • 1,602
    Kelshaer
    07-25-2012, 02:43 PM Go to last post

  28. Gantt Chart

    Started by Kelshaer‎, 07-25-2012 02:49 PM
    1 Attachment(s)
    • 2
    • 1,672
    Kelshaer
    07-25-2012, 03:40 PM Go to last post

  29. Double Click to add/remove Tick

    Started by smuzoen‎, 07-18-2012 07:01 AM
    3 Attachment(s)
    • 25
    • 62,829
    Pete_UK
    07-27-2012, 01:50 PM Go to last post

  30. Lightbulb Monthly expense report for colleagues

    Started by sreejith K K‎, 07-15-2012 11:35 PM
    3 Attachment(s)
    • 12
    • 3,421
    sreejith K K
    07-29-2012, 02:26 AM Go to last post

  31. Create Controls at Runtime/Expanding Forms/Floating Toolbar/PTO Calendar

    Started by BigBas‎, 07-31-2012 12:03 PM
    1 Attachment(s)
    • 1
    • 1,930
    BigBas
    07-31-2012, 12:16 PM Go to last post

  32. Completing partially-filled data

    Started by Pete_UK‎, 07-26-2012 06:02 AM
    1 Attachment(s)
    • 8
    • 3,659
    JBeaucaire
    08-13-2012, 10:56 AM Go to last post

  33. July Competition Winners

    Started by Vaibhav‎, 08-13-2012 07:33 AM
    • 9
    • 60,498
    BenMiller
    08-13-2012, 12:47 PM Go to last post

  34. Dynamic Cascading Drop Downs (getting around the INDIRECT() problem)

    Started by JBeaucaire‎, 07-03-2012 07:20 PM
    • 7
    • 14,570
    JBeaucaire
    11-30-2012, 01:23 PM Go to last post

  35. Listing/Renaming Files in a folder from excel

    Started by Kelshaer‎, 07-25-2012 02:21 PM
    1 Attachment(s)
    • 4
    • 2,923
    yozangwu
    01-23-2013, 11:04 AM Go to last post

  36. keyboard multiple select entire row w/o click and drag

    Started by vlady‎, 08-01-2012 01:14 AM
    • 1
    • 2,450
    harii143
    04-05-2013, 12:28 PM Go to last post

  37. An example using and scaling shapes (circle).

    Started by xladept‎, 04-26-2013 07:39 PM
    • 0
    • 1,677
    xladept
    04-26-2013, 07:39 PM Go to last post

  38. Fuzzy Lookup Add-In from Microsoft for Excel

    Started by alansidman‎, 10-12-2013 09:56 AM
    • 0
    • 11,470
    alansidman
    10-12-2013, 09:56 AM Go to last post

  39. Moved: Is there a way to highlight a cell if a value is < > or = to

    Started by Carpenter1375‎, 01-05-2014 09:21 PM
    •  
    •  

  40. Setting up ActiveX Scroll bar (tutorial)

    Started by AlKey‎, 06-23-2014 10:29 AM
    1 Attachment(s)
    • 0
    • 2,801
    AlKey
    06-23-2014, 10:29 AM Go to last post

  41. To exit Excel without prompting save dialogue and saving changes

    Started by Ragbirsingh85‎, 10-01-2012 12:15 PM
    • 5
    • 2,792
    Foremannvezc
    06-27-2014, 02:10 AM Go to last post

  42. Use F9 to evaluate a formula

    Started by newdoverman‎, 06-05-2014 03:59 PM
    • 12
    • 4,897
    FlameRetired
    07-04-2014, 03:19 PM Go to last post

  43. Evaluating Formulas

    Started by judgeh59‎, 07-29-2013 03:57 PM
    • 8
    • 3,935
    :) Sixthsense :)
    07-05-2014, 12:59 AM Go to last post

  44. IF AND OR in one formula

    Started by newdoverman‎, 07-06-2014 08:23 PM
    1 Attachment(s)
    • 2
    • 1,837
    newdoverman
    07-07-2014, 09:55 AM Go to last post

  45. Paste Link a chart from one sheet of workbook to another sheet of the same workbook

    Started by seagull6444‎, 07-17-2014 11:46 AM
    1 Attachment(s)
    • 1
    • 1,918
    Speshul
    07-17-2014, 11:51 AM Go to last post

  46. Advanced VLOOKUP

    Started by abousetta‎, 07-06-2012 01:50 PM
    7 Attachment(s)
    • 26
    • 15,867
    abousetta
    09-12-2014, 08:22 AM Go to last post

  47. copy random data in a row and place to its corresponding coloumn

    Started by hemakanag1‎, 11-02-2014 06:01 PM
    • 1
    • 1,959
    Pauleyb
    11-03-2014, 03:00 PM Go to last post

  48. Get Stock Quotes from Yahoo

    Started by ExcelClout‎, 11-12-2014 07:49 PM
    • 1
    • 2,778
    JBeaucaire
    11-17-2014, 11:59 PM Go to last post

  49. Tutorial on Understanding the basics of Conditional formatting

    Started by brocktoon93‎, 11-29-2014 12:24 AM
    conditional format, formatting
    • 1
    • 2,392
    Mykel
    12-02-2014, 05:45 AM Go to last post

  50. Goals planning and tracking Dashboard

    Started by Mandevu‎, 12-05-2014 01:45 PM
    1 Attachment(s)
    • 0
    • 2,400
    Mandevu
    12-05-2014, 01:45 PM Go to last post
+ Post New Thread
Page 1 of 2 1

Forum Information and Options

Users Browsing this Forum

There are currently 1 users browsing this forum. (0 members & 1 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