-
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...
-
Hi All, I need to connect one drop down menu to another. Hoping someone can assist here? For example, the first question in the spreadsheet (to the end user) is 'What would you like to review?'. The first dropdown presents two listings - 'Monthly Performance' and 'Weekly Performance'...
-
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...
-
Last week I was on holliday and we had to divide 3 bottles of wine among ten friends. We could have written our names on little papers and draw 3 names from the lot, but why do something like that when you have a computer with excel. So I wrote a array function that returns a permutation from a set of...
-
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...
-
Recently, someone at my firm created a DAYS360 formula " =DAYS360(A19,$D$11,FALSE)" and used the dates of Feb 28, 2002 - Feb 28, 2006 to calculate interest. For some reason, for the first year of 2002 it should return 1,440 days but is returning 1,438 days. I changed the "FALSE" to...
-
=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...