colmembernameiaqohsum

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Colmembername(IAQ_OHSUM,0,54)

resolvedResolved · High Priority · Version 2003

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.

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 tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips


Server loaded in 0.08 secs.