Search results

Without seing your sheet is't difficult to be sure but INDIRECT and ROW may sort it out e.g. =INDIRECT("A"&ROW()) If the data moves down, the row number changes and the formula still returns the same result. HTH Ed

Sorry - don't understand what you want. The formula provided gives you the remaining days of leave - what do you want to do? Ed

It would help if you had zipped a copy of your excel worksheet. Something on the lines of the below should work - you will need to put the actual cell references in =cell with total entitlement-Countif(range of cells that can have an L in them,"L") HTH Ed

Dependant drop down lists Hi, Check out this site - it's excellent http://www.contextures.com/xlDataVal02.html Ed

Hi Minky, The origins are in history. Originally with dial-up (56K etc), I had an email account, my wife had an email account, we had a family account, I had a hobby account. Then we got broadband and had to set up another broadband account which had anti-spam and filters and the like so it...

Hi there, I am using Outlook 2003 I have a number of email accounts and all these accounts forward their incoming to one master account on the server. What I want to be able to do is disable the receive on the subsiduary accounts when I send/receive to reduce the send/receive time and just...

Good to hear that you have a solution that serves your purpose - thanks for the feedback. Ed

It may be arbitary but it's the rule. The time span is predetermined and has limits and the formula will work with any time span. The rule may be arbitary but the logic of the formula overcomes it. I don't make the rules, I just overcome them! Ed

And it has logic! Ed

Hi Stephen, Try this as attached - it works for me! Ed

Hi, Check out this site for data validation advice http://www.contextures.com/xlDataVal02.html Regards Ed

Glad to have helped - thanks for the feedback Ed

Hi Matt Like this =SUMIF(B2:B20,"A",A2:A20) Repeat for the other criteria HTH Ed

Hi, You could only do this by using VBA to prevent changes being saved but you can't stop changes while it is being used without protecting the sheet. Protection is very weak and anyone with any knowledge can bypass it easily. Ed

Hi, Normally if you want to calculate based on multiple criteria you need to use SUMPRODUCT See http://xldynamic.com/source/xld.SUMPRODUCT.html. But if you post a sheet we can help further. Ed

thanks for the feedback Ed

For the cells with drop down values, highlight the cells, format, protection, uncheck protection. when you protect the sheet, check 'select unlocked cells' HTH Ed

Glad to hear it worked for you. Thanks for the feedback Ed

Hi shantigal Assuming the numeric part is always 5 digits Put this in the required cell and copy down =IF(ISERROR(MID(A1,FIND("ERAP",A1),9)),"",(MID(A1,FIND("ERAP",A1),9))) If you just want the number, =IF(ISERROR(MID(A1,FIND("ERAP",A1),9)),"",(MID(A1,FIND("ERAP",A1)+4,5))) let me know...

Hi, Yes, you have two options. One is to do all the work in the query report and do the summary every 50 rows, the alternative is to just dump the information in the queryreport and then create the other sheets to break it down into. can you export dirrctly from access? Probably, but I'm not...