cell function

Hi everyone ! I am trying to set a reference to external directory path in order to use it for hyperlink function (The hyperlink is used to either open the directory, sub-directories and sub files within these directories) to do that I'm using the following functions: 1. To set the main...

Hi Everyone, Would you be able to help me create a formula that will allow me to return multiple results, but then display the cell reference of each result I tried to use INDEX MATCH but it will only display the first match that it finds then return the cell reference of the match, this is the...

I have a big spreadsheet with macros that crunch some numbers and put out results in a new workbook: the workbook is protected, and so are all sheets, but with sorting and filtering allowed. The headers have auto-filter buttons. Issue #1: the auto-filter allows the user to filter, but upon...

Search and combining row and column data <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have been working on this with one other guy for the majority of the day and wondering if anyone has any insight. <TABLE style="WIDTH: 319pt; BORDER-COLLAPSE...