-
I have 2 worksheets. WkSht1 has 1 column A Client name Bob Tom WKSHT 2 has two columns Col. B has multiple client IDs per Client in Col. A A B CLIENT CLIENT ID Bob B123 B456 B789 Tom T321 T654 T987 There are variable numbers of IDs per Client I need a lookup to match on the client from WKSHT1 and retrieve...
-
Hi Nick, Many thanks for your answer, and this is what I had already thought I would have to do. However, if there was a way to do this within a formula, then this would have made it easier, as I have several of these formatting requirements throughout the spreadsheet. Many thanks for your help &...
-
Hi, I could do with your help again with regards to colouring text within a formula (nothing to do with conditional formatting). In a cell I have... ="INTEGRATED PEST MANAGEMENT "&UPPER(Tab_Name_Accommodation) which is all in black text. However, I want the INTEGRATED PEST MANAGEMENT in...
-
I have spreadsheets which have dates listed in Column A with other data in subsequent columns. There may be multiples (even hundreds) of one date listed (see example below). 5-May-08 6-May-08 7-May-08 7-May-08 7-May-08 8-May-08 There are also missing dates (e.g. 1-May-08 to 4-May-08). Ultimately, I need...
-
I have a spreadsheet of addresses that was scanned using OCR. The scanner did an acceptable job of text recognition, however due to additional Title's (i.e. MD, PhD, RN, etc) the columns in excel became wildly unmanageable. I need to extract Telephone, Fax and E-mail from a long list of contacts...
-
I have over 25 products where I have 2 years of monthly history and I am using the Trend Array function to forecast the next year. Every month I have a new month of data to add at the end of my actuals where the Trend funtion is located. How can I add my new month of data and not have to create 25 new...
-
Lately I've been coming across situations where I need to join one or more fields from a large dataset to another large dataset. The obvious answer is a vlookup. However, the speed of the vlookup drops dramatically the larger the datasets, which makes sense, a 100,000 row dataset being matched against...
-
=IF((AND(L16="H",H16>0)),(J16-H16+K16),IF((OR(L16="H",H16=0)),(H16+J16+K16),(IF(L16="D",(I16+DATE_TEXT(K16)),IF(L16="C",(H16+J16+K16)))))) When the user selects "d" in L16, the system needs to add a date such as 4/24/2007 in cell I16 and a number of...
-
HOW CAN I CHANGE THE FREQUENCY OF THE AUTO SAVE FUNCTION, THE DEFALT 5 MINUTES TO LESS THAN 1 MINUTE? PLEASE HELP
-
Roger Use an AND function =IF(AND(C1<>"B",M1="YES"),"YES","")