Search results

The Row function is used with small to make items unique. Say in your data 5 is repeated three times in a column. We make every value unique by adding a very small number. This number is generated by dividing row number by a very large value say 100000 so if the values are range A1:A3, then it...

Hello, There are two formulas that will work: For Range E13:E18 =IF(A4-E4<0,A4-E4+1200,A4-E4) drag down For Range F13 to right/downward =IF(E13-F4<0,E13-F4+1200,E13-F4) See attachment.

Can you check the above solution? Its 10 pm so will tomorrow mean while i will do "critical thinking":) good night

You are welcome. A Subject can be taught by only 1 teacher? or there are more then 1 teacher per subject? What if we do it this way?

Hello kmahraz, Please see attached solution, it is not fully automated but if the solution is ok then we can still workout.

Ok dear let me attempt :) lets see if we remain sucessful or not.

..and the area between the session and the room will be occupied by subject name?

What is the critieria for session i.e. how many classes do you need to have in order to have a session? What is the relation of room and location? is the class same as room or does it refer to a subject?

The last section of session and classes needs explantion can you elaborate. Mean while you can see this attempt.

I am unable to understand the stuff related to session and classes. What are session? it is like semester or something else?

From your post i have understood that .. Associate = student classes = subject offered instructor = instructor Can we work with smaller sample of data to model the problem?

Hello, Have you tried developing a solver model for this problem??

Hello JCTalk, I regret the formula i mentioned count "Unique" values and not duplicates. Please go by @Bosco's formula as it is producing correct results. Thank you.

can you provide a larger sample of data to see what is going wrong?

Hello, Try this: =SUM(IF(FREQUENCY(IF(A2:A100<>"No IP address",1,IF(A2:A100<>"",MATCH(A2:A100,A2:A100,0))),ROW(A2:A100)-ROW(A2)+1),1)) With ctrl+shift+enter Idea Adopted from: http://stackoverflow.com/questions/20532773/how-to-count-unique-values-in-excel-with-two-conditions

Hello Please check attachment. Thanks.

..But where is machine column A to D?? In which sheet?

Kindly attach a sample worksheet...

You can do it with Slope and Intercept Functions. Please see attachement.

Hello, Please see attachement for workout. The formula has been adopted from Get Digital Help's following Link: http://www.get-digital-help.com/2009/06/29/merge-two-columns-into-one-list-in-excel/

Hello, The problem was in your data and not in pivot table. If you look at your data, some of the cities were missing either of the age categories. For Chicago, there was no entry for age bracket >= 2, similarly for London there was no entry for bracket 0-1. When you are making pivot table...

It is not"consensus" but my humble opinion. Any one else can surely do that without helper column. As i was reviewing the worksheet it appeared that either some very tricky formula or a very lengthy one will solve the issue. But as i have observed in course of time, both become problematic...

Can you share the spread sheet. It is an optimization problem to be solved with SOLVER. I will be glad to help.

Hello bob, it will need at least one helper column to repeat the name of person...

Use text to column feature of excel and then use DATE() to combine various components into date and format ad DD/MM/YY.