Search For:

Your answer seems to be another question unless I am reading it wrong, or I am just cluless, but I don't understand how what you wrote relates to my question. Clarify if you were attempting to...

I wrote a line of code to rename worksheets in my excel spreadsheet, and it executes perfectly at home where I have 2003 software, but at work where I need it to run, I get the following message: ...

True! Sorry about that. Great code. Thanks. Such a simple solution, but I haven't done vba in so long, I couldn't even remember how to do elseif statements! :D Thanks for the help!

So simple! :D However, there now isn't a line of code to unprotect every worksheet. Would I need to embed another if statement. Because I still need the line, if protect contents is true then...

I have used the code from ozgrid website to protect all worksheets, but then I have worksheet in the workbook where users need to insert objects, and they will not be able to if that worksheet is...

Dave-
I see how that would work. That is awesome that you can just build the arguments of the function like that (but I guess that would make sense seeing how it is a UDF). I never imagined...

So I have a UDF for a lookup_occurrence formula (thanks to Dave), and I was wondering if it was possible to tweak the range it looks at with if statements.

I have a formula like this...

Yes, thank you I got it to work. It was a layout issue with my table. I am learning :D

Thanks!

It didn't work; it is still just repeating the loop. Right now I have the value "Katie" as the 1st occurrence of high, and the value "Randy" as the 2nd. With my lookup_occurrence formula I went all...

Thank you,; it is working fine! The only other thing is it loops clear back to the beginning. So if I am the formula reference the 7th occurrence, and the 7th occurrence does not exit, it returns...

I have that custom function; is something different with this one?

And what attachment; I did not see attachment.

I did see that. Your example however is referencing cats, which is only a value in your table.

My references are formulas that return high, med, low, and the lookup_occurence is not recognizing...

Well I figured out why it was returning #value, but I need a way to fix it.

The lookup_occurence formula is looking for the first occurrence of B8 (which currently says High), and returning the...

This the lookup Custom Function.Lookup Occurence


Function Lookup_Occurence(To_find, Table_array As Range, _
Look_in_col As Long, Offset_col, Occurrence As Long, _
Optional...

Sorry, I am not trying to assume a means to an end at all.

The teacher puts in the students score (didn't mean imported sorry).

I thought I have explained what I want. Everything is fine...

Here is the updated attachment with made up data in the cells.

Well then I don't know how to do that if I can't have formulas in the data.

I don't know whether a student will be high, low, or medium....until a score is imported for them. The formula then...

Okay I have attempted to layout the data as you requested. I put 2 exit cards and 3 periods on the sample sheet. (Keep in mind it will be 8 periods and 10 exit cards per unit with 5 units total on...

I apologize in advance for my ignorance, but I don't see what you are referring to. I have all related data together.

I guess I do not understand what you mean by the terms raw data and data used...

Sorry, I thought it was clear. The post I made about playing around with some coding was a response to your post.

So is it impossible to embed the indirect(n5) into the array position of the...

Bill--- Yes that is the approach I was thinking, with a slight modification. However, it is the coding for the macro that I am at a loss at. Any thoughts?


FOR DAVE
Dave-- I read that thread...

Dave, I did see your post with the vlookup, and I read it.

The reason why I changed it to lookup_occurence is because I need it to return a specific occurence. 1st occurence of high, then...

Okay, I am assuming my original thought may not be possible, so here is what I am thinking now.

When a teacher selects the class period and the assessment (i.e. conflict or test #2 etc), then it...

SEE SECOND POST I HAVE CHANGED WHAT I AM LOOKING FOR TO WHAT I THINK IS A BETTER SOLUTION TO MY PROBLEM

This is in my mind a complicated problem; I will do my best to describe it.

I have...

While coding the group if statements, I just realized another problem; however, since it deals with asking another question, I have posted it in another thread. If you think you know how to solve...