Search results for query: *

Ahhhh Skip, you have such great foresight . . . [dazed] I have finally got it sorted, rather complicated (in my mind anyway) I moved the data to another tab and came up with this, it seems to work ok (Fingers Crossed) =IFERROR(IF(ISBLANK(INDEX('Whangamata...

Sorry guys, Now I am even more confused. I will try to explain the process from go to whoa 1. Field rep gets data and enters it into an app 2. App enters it into a 3rd party server 3. 3rd party server sends daily report out at about 4am 4. Report emailed directly to me, field reps (different...

This spreadsheet is emailed to several different users at about 4am daily (weekends included). It is also opened on random occasions by other users wanting information from it. To use a macro in this way would be extremely difficult to administer. Please remember, I am a user that has been...

The file is transmitted from the server at 4am to the users. Data is collated from various tabs to this tab for the users to use. As I noted above, macros are stripped from the file before it is generated so macros are not available. Obviously harder than I anticipated. Never mind, all is good...

Thanks Andy, I finally figured that part of it out, I stripped the < out and I realised it works fine, however I do need the < sign as its for legal compliance Can anyone help me with a way to get them across to the right tab? I have also tried index/match but the same result. I was thinking...

The problem is a "simple one" I am sure. I am using the MAXIFS formula but it is not transferring all the data. I have tried to put an explanation in the attached spreadsheet. While there are about 30 tabs to the spreadsheet I have left two open. The rest I dont think are relevant to the case...

Thanks Guys from a small Town Council in New Zealand. Worked perfectly I tried both methods and found that Unique() and MaxIfS() worked best for my application. I didn't even know they existed until I got your emails. Have a fantastic Day. With respect Wicca Believe in yourself, you are...

This is what I get from the network and need to get the largest number for each day With respect Wicca Believe in yourself, you are worth the investment.

A few more lines from the spreadsheet that may help with your thoughts . . Im totally baffled but then I am not great at this anyway 8700-3655 Bell Operating Bore Sites 4,819.54 32% 4,819.54 32% 15,000 15,000 8700-3660 Bell Operating Reserviors 482.24 40% 482.24 40% 1,200 1,200 8700-3665 Bell...

Hmmm I have a similar problem but not as easily solved I have the following text data in one cell and wish to break it into individual cells 8710-2000 Bbri Water Salaries 741.34 2% 741.34 2% 36,488 36,488 8710-2010 Bbri Water Travel/Accomm 164.27 21% 164.27 21% 800 800 I used left(CELL,9) and...

Thanks guys, I think I have the answer . . . you guys are awesome With respect Wicca Believe in yourself, you are worth the investment.

Account Description Total Margin Account Description Total 1/3000/01 SALES TRACTORS formula 2/3000/01 SALES TRACTORS...

Close but not quite. Yes I can insert a new row and that was good. I did put data into the cells that equated to the non-formula cells however, when I went to put data in the column that had data in, I was unable too as it said the cell was locked. With respect Wicca Believe in yourself...

I know this may sound like a silly question however, I have a manager that insists on overtyping formulae. I have a 600 line by 30 column speadsheet and every 4th column contains a link to a seperate worksheet. eg =Otorohanga!$C4 =Cambridge!$C20 =Rotorua!$C344 Every time he uses the...

Well, I have just used a VBA program in Excel (of course) and reduced a monthly data analysis task from 3 hours to less than 10 minutes . . . the majority of that time is actually inputting the data into the spreadsheet . . . a single click of the macro and its done and dusted, sorted, formated...

Thanks . . . now the accounts can go through with HAPPY accountants Cheers With respect Wicca Believe in yourself, you are worth the investment.

I have a series of cells that are all ACCOUNTING Formatted A B C D $43,622.43 $42,770.78 $851.65 $0.00 $20,089.53 $19,348.89 $740.64 $- $23,465.76 $23,087.19 $378.57 $- $29,706.87...

ROFLMSO that was so much fun to read . . . I use a 13 digit alphanumeric with special characters capitals and lowercase. I consider that to be secure enough for most instances . . . but it would not take ALL THAT long to crack if someone really wanted to . . . luckily my need for security is not...

Skip, Is there anyway I could put you in a carry all and bring you to NZ . . . you are awesome, thanks so much for this post Merry Part and the Brightest of Blessings With respect Wicca ----- IF you think you can Or If you think you can't Then You are probably right -Henry Ford

Ya know what Skip, sometimes I wonder if anyone ever reads the FAQ and good bits that people have left here. I see over and over this question and your reply. Thank you for your patience. Cheers Wicca