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

Forum: Excel Tips

  1. UK Postcode Distance Calculator

    Started by Pete_UK‎, 07-14-2012 08:18 AM
    distance calculator, uk postcodes 2 Attachment(s)
    • 15
    • 68,927
    AliGW
    10-18-2022, 05:01 AM Go to last post

  2. 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

  3. 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

  4. Dynamic Cascading Drop-Downs Using INDEX & MATCH

    Started by GeneralDisarray‎, 07-07-2012 12:03 AM
    7 Attachment(s)
    • 4
    • 31,466
    Ginge1267
    09-06-2017, 11:13 AM Go to last post

  5. Unhappy Excel 2007 Color changes when I copy a worksheet to another workbook:

    Started by Artedk12‎, 10-18-2015 01:04 PM
    1 Attachment(s)
    • 1
    • 22,695
    Aardigspook
    10-19-2015, 09:13 AM Go to last post

  6. 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

  7. 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

  8. 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

  9. Excel Formula Errors and Their Meaning

    Started by panel123‎, 04-28-2018 06:09 PM
    • 0
    • 12,488
    panel123
    04-28-2018, 06:09 PM Go to last post

  10. "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

  11. 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

  12. COPY/ PASTE VALUE keyboard shortcut

    Started by vlady‎, 07-12-2012 09:57 PM
    • 4
    • 5,839
    david12
    10-06-2018, 04:40 PM Go to last post

  13. 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

  14. Generate fake data sets for when posting Excel tables with data

    Started by Keebellah‎, 08-01-2018 04:45 AM
    1 Attachment(s)
    • 16
    • 5,097
    sandy666
    12-29-2022, 02:18 PM Go to last post

  15. 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

  16. 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

  17. How to Insert Formula by using the Macro in Microsoft Excel

    Started by Nisha Dhawan‎, 04-02-2015 06:00 AM
    • 3
    • 4,619
    Kaper
    04-07-2016, 03:10 AM Go to last post

  18. 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

  19. 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

  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. Screen shot tutorial on 15 Excel Functions

    Started by brocktoon93‎, 11-08-2014 09:21 AM
    formula, functions, vlookup
    • 3
    • 3,492
    Doc.AElstein
    02-20-2015, 09:03 AM Go to last post

  22. A video about combining VLOOKUP and COLUMN

    Started by RossSharma‎, 10-14-2017 07:12 PM
    • 5
    • 3,435
    RajGamer
    08-20-2021, 01:29 AM Go to last post

  23. 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

  24. How to get cell data based on row and column values

    Started by harisway‎, 05-26-2015 09:05 AM
    1 Attachment(s)
    • 3
    • 3,347
    malwinasokol
    09-16-2015, 03:34 AM Go to last post

  25. Question Change "Commandbutton" to a variable

    Started by amipierre‎, 10-10-2016 08:26 PM
    • 2
    • 3,165
    amipierre
    10-10-2016, 10:31 PM Go to last post

  26. Inquire Tab on Ribbon

    Started by alansidman‎, 11-08-2015 12:37 PM
    • 1
    • 3,133
    xladept
    11-08-2015, 03:37 PM Go to last post

  27. I can't make this countif equation work. Help

    Started by Holden Wright‎, 02-03-2016 07:40 PM
    countif, times
    • 5
    • 3,104
    Pete_UK
    02-04-2016, 06:30 AM Go to last post

  28. Lightbulb Automatically process data from CSV files into pre-existing Excel Tables

    Started by pfrattali‎, 10-16-2016 10:51 AM
    • 2
    • 3,057
    cytop
    10-16-2016, 12:16 PM Go to last post

  29. Index Match & Array Formula Training

    Started by billgyrotech‎, 12-19-2016 11:23 AM
    1 Attachment(s)
    • 4
    • 3,055
    AliGW
    12-19-2016, 12:10 PM Go to last post

  30. mirror

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

  31. 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

  32. 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

  33. 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

  34. 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

  35. 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

  36. Named Formulas

    Started by Vince42‎, 06-19-2017 04:55 PM
    expert, named formula
    • 4
    • 2,729
    Vince42
    08-06-2017, 04:00 PM Go to last post

  37. 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

  38. '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

  39. 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

  40. Please help, how do you insert multiple numbers into one cell?

    Started by Stephen1978‎, 03-01-2016 09:01 AM
    • 2
    • 2,418
    Stephen1978
    03-01-2016, 11:20 AM Go to last post

  41. 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

  42. 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

  43. 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

  44. Sticky Topic for Fixing Corrupt Excel Workbooks

    Started by hrlngrv‎, 02-09-2020 05:32 PM
    • 2
    • 2,357
    DannyPhilips
    09-07-2020, 04:01 AM Go to last post

  45. 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

  46. 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

  47. 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

  48. If cell a= 11 then cell 6= John

    Started by Sionach‎, 08-23-2016 08:19 AM
    • 2
    • 2,198
    FDibbins
    08-23-2016, 09:02 AM Go to last post

  49. 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

  50. Problems in exporting to web page

    Started by GiMan‎, 01-30-2020 02:11 PM
    • 2
    • 2,073
    Roza1
    12-01-2021, 07:57 AM 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