Search results

After login, you could set a 'TempVar' property, using the member's ID. Then use that to filter any forms that load thereafter.

Good on ya Mike :) Glad it worked out, and glad I could assist.

smiler44. If you are copying and pasting the CELL, it will make a relative formula, ie: shift the cell references relative to the original copied cell (hope this makes sense). If you are entering the formula correctly, on ANY cell, then it will work regardless. Attach the spreadsheet and...

Well, actually! I just learned something! Thank you Brianwarnock! Where were you 2 years ago when I was trying to figure this out? =SUMPRODUCT((c5:c30="jon")*(f5:f30="good")) Thank Brian for that.

Right, then the easiest way by far, is to add another column next to the rows and follow the procedure I posted before. I've tried this before, and pre-2007, it's the easiest way without getting into VBA.

The way I USED to do stuff like this, was just add in another column. (a hidden one somewhere) for example.... Column G. the formula would array from g5 to g30, and would be like so..... =if(and(Cx = "jon", Fx = "good"),1,0) So all the rows with Jon and Good, would return a 1. The rest would...

are you using 2007 or 2003?

No worries smiler44 ;) been there, done that!

And I'm assuming you used QNum as the Question number right???? Your Select Case statement as it stands will only allow it to calculate if QNUM=1

You need to create the code seperately for EACH question! Try This.... Dim Total as integer Dim Q1 as integer Dim Q2 as integer Dim Q3 as integer Total = 0 select case true case optQ1Bad.value=true '<--------Bad Q1=1 case optQ1Normal.value=true '<--------Normal...

It usually comes from recorded macros. Instead of using range("a1:a2").select selection.copy range("a3").select activesheet.paste etc etc etc use something like: Range("E10:F12").Copy Range("H10") quick and easy ;) and no funny flashing lines.

Have you got a filter applied to the form? Or a Where Condition?

No worries ;)

Did this do the trick?

Hmmm, I'm not sure.... My apologies, I'm merely a learner...

You should just need to put "NO" in the first criteria row. The rows are OR criteria. For example if you only want to show YES and NO, then you would put YES in the criteria and NO in the first OR row. That translates to: Show records where Answers = YES or NO

No worries! You're welcome.

as an example: in the H7 cell: =if(iserror(0/0),"",0/0) basically, if Zero divided by Zero produces an error (it WILL produce an error), then make the cell read BLANK. Else, the answer is Zero divided by Zero.

would it be difficult to amend the cells with the DIV/0! error? I usually put: =if(iserror( your formula ), "", your formula) This will make the cell return a blank (equal to 0) rather than an error.

It's tricky, as there is probably I don't understand if you need to divide by the count or not, but you would simply append the countif statement to the end.... =(H7*(0.2)+J7*(0.05)+L7*(0.1)+N7*(0.25)+P7*(0.15)+ R7*(0.1)+T7*(0.15)) / countif(H7:T7,">0") It should only count the numeric...