Search results

I am struggling to create a formula that will make sure there is a date in a cell is certain text is in another cell F107 contains a Data valadaion list which has 3 options Blank or "Pro Rota until" or "Annually from install" I107 should be blank if F107 is Blank or contains "Annually from...

Narayan Sorry for my delay in getting back to you. The version on our servers is 2003 Hope that's helpful? Sean

Narayan Please find the file in dropbox http://dl.dropbox.com/u/66314380/Project%20Tracker%20columns%20sorted.xls I have put some instructions in the instructions tab Many thanks Sean

I'll have a look at it first thing in the morning and see about getting a copy for you. Sean

Narayan, Thanks for your interest. 1 There are no formula in the spreadsheets is is purley data caption. There is a link to another spreadsheet. Each person who own one of the 4 individual s/s will be responsible for updating their columns, and will not touch the other columns, but may be...

I have 1 x Master spreadsheet that collates all information, and 4 identical spreadsheets that 4 single people work on. Each of the 4 people are responsible for one section of the spreadsheet, say 10 columns each. but all of the information then needs to updated on the master spreadsheet. The...

Hi SirJB7 basically I want it that anything imedietly under Bundle in column A that says Inc (or something else) the figure in the Total price is reset to zero. In the example the bundle includes the main item and a, b, c, d but not e.It may be that there are further items in or out of a...

I have a order and I want to show the individual prices but my marking 1 item as a bundle and other items in as included (or some neat presentable way of doing that)that I can show a new bundle price and other row total cost See example (how that looks ok) QTY Item Cost price Total price...