Search results

If you are trying to use the entire expression with another IF(ISNA combination, you have exceeded the limits of the formula in a cell, 1,024 characters. You already have 587 characters as it is (in my formula). If you double it, then you have 1,174 characters. Given the increasing complexity...

Great. Glad I could help. ________ Hawaii Dispensary

Howdy. Your COUNT portion is referring to the active workbook. If you want it to count on the other one, then add the reference ahead of the COUNT function: SUM(OFFSET('[HugeReport.xls]DMR'!C15,0,COUNT('[HugeReport.xls]DMR'!15:15)-7,1,7)) ________ Ds7

Howdy. If you put this formula in E5 =IF(B5="","",SUM(E4,B5)) And copy down. Will this work? ________ Volcano Vaporizer Reviews

Okay, your formula above does not match what you have in the example workbook. Try this in H2, based on the sample you provided. Your problem was that the IF had no means of "escape" to the correct answer. I reversed it and it seems to work. Note that I separated the individual lookups into...

Sorry for being so old and dense, but how are you determining whether it is EQY01 or EQY02 etc.? You have to have some specific instance for the formula to return. So at the simplest step, what is your criteria for EQY01, so that we can get a specific value in H2 (building the easiest formula...

I understand. But in this specific instance what value do you expect in H2 instead of TRUE? ________ Buy Vapir One

Howdy. What exactly do you expect in cell H2? ________ LF

So, what exactly do you have in the formula for the condition? ________ Lamborghini silhouette specifications

If you begin checking with a few test values, it depends on what "average" you (OP) want. Do you want the average if only two items are filled, then my formula works. If you want the average including all blank cells, then the array formula gives you what you want. They produce different...

Can you post what you are using for each condition? ________ Maryjane

Then I think you need something like this: =IF(AND(MAX(AN155:AN184)=0,MIN(AN155:AN184)=0),0,AVERAGE(AN155:AN184)) ________ Montana Medical Marijuana Dispensaries

Howdy. That means that there is an error in the formula result. What are you trying to do with your IF statement. ________ HAWAII MEDICAL MARIJUANA

Howdy. How is the conditional formtting done? Is it by VBA code or traditional Conditional Formatting? Do all have the same version of Excel? ________ HOT BOX VAPORIZERS

The following will give you the MIN for any item in Col A. Put this in F2 and copy down. =INDEX($B$1:$D$3,MATCH($A2,$A$1:$A$3,FALSE)-ROW()+1,MATCH(MIN($B2:$D2),$B2:$D2,FALSE)) ________ MAINE MEDICAL MARIJUANA DISPENSARIES

Okay, use the INDEX/MATCH formula to provide what you want. This assumes that your data (including row and col headers) is in A1: D3. =INDEX(B1: D3,MATCH($A2,$A$1:$A$3,FALSE)-1,MATCH(MAX(B2: D2),B2: D2,FALSE)) Actually, if you put the following formula (more flexible) into cell E2, then you...

Howdy and welcome to the board. We would need to see your code. Are your drop down lists Combo boxes, List boxes, or Validation Lists. You can achieve the dependent lists without VBA by using Validation. Check out Dependent Lists. ________ LOS ANGELES DISPENSARIES

Howdy. Do you mean objects on the spreadsheet? If so, your macro needs to select all objects. ________ MARIJUANA VAPORIZER

Or without using VBA, select all the rows (2 and below) you want (assume that your headings are in row 1). Then go to Format > Conditional Format, and on the left from the dropdown, choose "Formula is". In the box to the right, put in this (Be careful to include the dollar sign): =$C2>0 Then...

Howdy. Can you provide a small sample of how your data is arranged, and then how you want the output? It might be that INDEX/MATCH combination will be better. ________ VAAAPP VAPORIZER