Search results for query: *

Hi all, Hoping someone can assist.. I have a list of data: City | Person New York | David New York | Pamela LA | Colin What i want to do is group all the persons from the same city into a list against that city name: New York | David, Pamela LA | Colin In the second column i just...

Hi All Bit of a straight, to the point question... I am commecning build of a new website, that needs a backend DB to hold user/transaction info etc. Users i hope to be >1000. I have lost track of current trends in development world, what is my best/preferred software to pick up knowledge on...

Hi guys Hoping someone can help. Basically i have a workbook containing 1 worksheet called 'Sheet1'. Data is contained in columsn A: BD. In Cell A there is a Region listed, and what i need to do is split out into a new workbook the rows pertaining to each region. The region is sorted in Region...

Hi All Wondering can anyone help. I have a worksheet (Sheet1) that holds this data: Item Date Stock A 10/08 50 A 12/08 30 Sheet 2 holds Supply information: Item Date Supply A 11/08 50 What i need to do is lookup in Sheet1 to see if there is due...

Hey all, Been stuck on this formula for past hour! Item DemDate DemQty SupDate SupQty Supply 1 10/08/2011 62 20/08/2011 500 0 1 11/08/2011 106 20/08/2011 500 500 1 26/08/2011 106 20/08/2011 500 0 2 26/08/2011 100 20/08/2011 100 100 The SupDate indicates when a supply of...

Hey guys I have a reports form that allows users to select the type of report they want (based on cascading combo's) and they can then turn other filters on/off. When complete they click CREATE- this looks up the report they have selected and presents as print preview. Now what i want is to...

Hey all Lookup time... Ok. Sheet 1 has 2 columns, Machine and Qty. Machine-Qty 1-25 2-10 3-20 What we are saying here is Machine 1 can make 25 units. On sheet2 i have another table that basically has Machine in column A, Output column B, People column C. Machine-Output-People 1-50-3 1-100-4...

Hey all trying to write a macro that will remove any date filters from a pivot table and then filter the Date field again between 2 variables- dStart and dEnd Pivot table is called PivotTable1. Field is called Date. Cell B2 contains the Date filter. I am not sure how to do this- i tried...

Hi All Need some help with a formula: I have 2 rows of data In row 1/2 i have each day of the week and a number below: Mon Tues Wed Thus Fri Sat Sun Mon Tues Wed Thurs Fri 3 3 3 3 3 In the next row what i want to do is simply look at the above row and...

Hey all relatively simple one though i am unsure as to the best design principle to implement it. I have set my cursor on a cell in row 1. I want to copy from this cell (e.g Current Cell= G1) to the end (i.e. where the last record of data is in column G. I jsut need to know how to best select...

Hey all Having some trouble with searching for a value in a range. On Worksheet 'Sheet1' cell A1 i type a value e.g. 4 On Sheet2 row 1 there are 10 columns of info. Columns C-L contain the values 1 to 10. i want a macro to pick up the value in Sheet1!A1 and find this in the range A1-L1 on...

Hey all got a conundrum in excel that im not too sure how to sort! I have a list of Jobs 1-10. I have a number of operators in a team who do these jobs. The jobs they do depends on the size of their team e.g. 3 in the team: Person 1 does jobs 1-3, Person 2 jobs 4-7, Person 3 jobs 8-10. 4 in...

Hi All I have the followi9ng formula that essentially checks a cell to ensure it has a value that isnt empty or says "holiday" and then proceeds to do a lookup into a pivot table to retrieve a value. I am getting N/A errors now when the lookup fails so i want to wrap the formula in a ISNA or...

Hey all Quick Q....i have a pivot table that already has the data sorted the way i want it. when i create a pivot table it auto sorts against the first field. How can i prevent this? Unfortuantely there is no straighforward sort ie. Ascending/Descending. The sorting is done in the query against...

Hey all i have a table that records the following data: Product A Start ID: 1 End ID: 50 What this table is recording is that we shipped 50 of Product A and their IDs were between 1 and 50. What i would like to do is to query this table and ask where was ID 40 used? It would therefore return...

Hey guys I have this formula in a cell O14: =IF(ISBLANK(A14),"",MAX(IF(A14=A13,S13,$C$3))) Basically checks if A14 is blank then have no value else if A14=A13 use the value in S13 else use the value in C3. What i would like to do is add another check in that says if there is a value in C14...

Hey all Bit hard to describe but will give it my best. I have a sheet that works out how many of a product can be delivered on a certain day, and is laid out as follows: Date: 15/05/09 | 16/05/09 | 17/05/09 Prod A: 50 60 70 Prod B: 0 10 50...

Hey guys I have the following calc going on: =IF(ISBLANK(G19),"",G19-O19) You follow the logic, BUT i want to only show it if the result is a positive number ie. >0 How best to achive? Cheers guys for your effort.

Hey all On a spreadsheet i want to have a cell that has the current date + the time set to 8am. If i do current date/time it will give me: 28/04/09 17:25 What i would like is for it to show: 28/04/09 08:00 ie. the current date AND 8am as the time. i'm not sure of this can be done, then i...

Hey all i have a workbook that i share ro allow other users to make changes. The other users leave the file open to view and edit as required. What i noticed was this file grows in size considerably e.g. it starts off at 192Kb but after an hour it grows in size to 5Mb and continues this...