Search results

Hui, Yeah, I realised that, but I added it to try and make it clear after Oscar's post as his confused the issue I felt and you (seemed to) support him by offering a different solution. I tried to clarify it, seems I failed :)

<<If entered exactly as above, this only returns a #VALUE! >> Did you adjust date_range and value_range to your ranges, and size them the same as A3:A80?

<<If you are using dates you can't use "2010-10-01" as that is text>> No, but you can use --"2010-10-01" as I showed.

Use =SUMPRODUCT(--(A3:A80="D"),--(date_range>=--"2010-10-01"),--(date_range<--"2010-11-01"),value_range)

Something along the lines of =SUMIF(date_range,">=2010-10-01",value_range)-SUMIF(date_range,">=2010-11-01",value_range)

Try this "<Link ((<LEV(""Customers"", ""Lev0,Customers"")) AND ( <IDESC("""&A1&""")))"

I don't get a #NUM! in either case, I get blank both times.

I guess it may be possible to extract from a PDF in VBA, but I am guessing it is hard work. I use a third party tool, http://www.investintech.com/able2extract.html, and use that output.

My example shows all results in adjacent cells if you drag the formula across. I would suggest that this is the best way to do it.

Not with Data Validation. It can be done with a combobox, but that is a less friendly control in other words, so my advice is regrettably to live with it.

Try using this array formula =IF(ISERROR(SMALL(IF($B$1:$B$20="SATURDAY",ROW($B$1:$B$20)),COLUMN(A$1))),"", INDEX($A$1:$A$20,SMALL(IF($B$1:$B$20="SATURDAY",ROW($B$1:$B$20)),COLUMN(A$1)))) copy across as many as might be needed. This is an array formula. This means that you use...

ARe you sure that the value is exactly 0.451,, either value, it may have other decimal places that are not showing.

Quite honestly, I have watched you spraying questions all over the place, at many forums,and it is my considered opinion that you would be a nightmare to work with. I would suggest that you sit down in a dark room and properly consider what it is you are trying to do, what your business drivers...

Doesn't this do it =D5=MIN($D5,$H5,$L5,$P5,$T5)

BTW, why are you using COUNTIF. I would use =--($Z$1=1) etc

<br /> Private Sub Worksheet_Calculate()<br /> Dim cell As Range</p> <p> Application.EnableEvents = False</p> <p> For Each cell In Range("Z38:Z63")</p> <p> If cell.Value2 = 1 Then</p> <p&#62...

It might do, if we could actually see anything other than the question.

Try =B5=MAX(D5,H5,L5,P5,T5) obviously it cannot highlight B5, but it won't be a problem to add the C F to too many cells.

Absolutely not! You could turn off screenupdating and set calculation to manual at the start and reset at the end as well as not selecting.

Why not just use =LARGE(ROUNDDOWN('2010'!$D$3:$D$5+'2010'!$D$8:$D$13,0),ROW(A1)) and copy down

Is that you want =IF(SUM($B2:B2)>9000,0,IF(9000*8.6%>SUM($B2:B2)*8.6%,B2*8.6%,9000*8.6%-SUM($B2:B2)*8.6%))

I you do use Hui's suggestion, be aware that the cells contain strings thereon not numbers, so you cannot do math with the value in that cell.

You need to explain that data in more detail, and the correlation between those two worksheets.

What determines when you add a SUM? If it is a value in another column, just use the SUBTOTAL function in Excel.

Just saying it doesn't work doesn't help much. You need to post a workbook, because you have clearly done something wrong but you are not able to express it in a way that we can resolve.