Functions

Drop Downs and lookups from other sheets
I have a workbook where the front sheet is a display page and the three sheets behind are reserved for data tables. What I want to do is have one cell in the front page which is a drop down and selects names from one of the tables on the other sheets. From there I can use Vlookup to populate the info from the... 19 Apr 2010 12:37

i dont know if sumif ,,,,, please help
i have 2000 rows and 2000 columns in one column, after searching for this product x. this value of all the product x will be summed up on below , for every search, there will be automatic sum for every product.(is it possible?) this is sample data (these are filtered items) col b ... 19 Apr 2010 09:30

Date refrencing
hi i have two sheets one is inventory the other is summary with the same style and clumn headings. now i want the date of the summary sheet to record the dates put in the inventory column but when i use the formula i get 1900 year, i suppose becos i yet dont have dates but is there a better way of doing this th... 20 Apr 2010 11:22

COUNTIF PROBLEM
Hi, I am using the countif formula in my spreadsheet to count the number of times "DPRS" appears in say column G. for some reason it keeps givong me the wrong answer i.e. instead of 29 I get 9 as the answer.When I filter for "DPRS" I get 29. There are no blank cells in between. Thanks, Manir ... 19 Apr 2010 09:30

Check the lasta character
Dear All i have a range of coding where some of them are ending in letter I. There is any way to group all of them? Or is it possible to create an if function when the code in ending in I gives true and else false. Thanks in advance for your valuable time.... ... 19 Apr 2010 05:21

hiden cells copied automatically to another workbook, can I stop .
I have selected data from a workbook that is automatically updated to another workbook. It also copies the hiden cells, can I stop the hidden cells from automatically be copied? ... 19 Apr 2010 04:19

Compare two columns with different codes
Dear all I have two columns with codes. The first column include the main coding (ie: ab1, ab101, ab10101,...) The second column include the same codes, but the first leter is always C. So the coding is (ie: cab1, cab101, cab10101,...) I have notice that some of the codes in the second column are missing. There ... 19 Apr 2010 04:19

need help with formula
Hi all, I am in a tricky situation. i have a table which basically includes 6 Columns. Date, Location,Location 2, No. of pieces, Weight, Pallet/Container. Then i have another table on sheet 2 with 9 columns, Location, Location 2, Container Dec., Container Jan., Container Feb., Pallet Dec.. Pallet Jan., Pa... 19 Apr 2010 01:12

Finding duplicate addresses
If you could help me with this it would be greatly appreciated. Column A Has client codes Column B Has client names Column C Has client addresses The same address may be used for multiple client codes. I am only looking for duplicate addresses. What I would like to end up with in my report is onl... 19 Apr 2010 17:48

How do I match 3 different workbooks information for similar data?
I am working with 3 different workbooks that contain some similar data. I am trying to find a way I can match up that data in a separate workbook. The first workbook I pull off a website, the other two are also pull out of a company website. These three sites give me a option to save as excel spreadsheet. What ... 18 Apr 2010 21:57