Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Colmembername(IAQ_OHSUM,0,54)

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Colmembername(IAQ_OHSUM,0,54)

Resolved · High Priority · Version 2003

Reply Fri 23 Oct 2009, 14:37Delegate Linda said...

Linda has attended:
Excel Advanced course
Powerpoint Introduction course

Colmembername(IAQ_OHSUM,0,54)

The above formula is in a spreadsheet I have inherited.
Please can you explain what it is doing.

For upcoming training course dates see: Pricing & availability

Reply Fri 23 Oct 2009, 14:52Trainer Amanda said...

RE: Colmembername(IAQ_OHSUM,0,54)

Hello Linda

Thank you for your question and welcome to the forum.

This is not a standard Excel function, nor does it appear to be a function that would be available if you installed any of the Excel Add-ins. It is most likely that it is a bespoke function which has been written using VBA code, in which case we unfortunately cannot shed any light on what it does - sorry.

Kind regards
Amanda

Fri 30 Oct 2009: Automatically marked as resolved.

Excel articles

· Advanced level training: Microsoft Excel and the Web
· How To Avoid The Embarrassment Of Dirty Data
· How To Use Conditional Formatting In Excel
· Joseph And His Chart Of Many Colours
· How To Identify The Most Critical Data In A Large Excel Spreadsheet

Please browse our web site to find out more about
advanced+excel+training+in+london and other Microsoft training courses.

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips