Search results

thank you all for you quick reply i will check them all out shortlty

I am trying to lookup up the attendance day and time in the Attendance Table (on the top) within the program table (on the bottom) and return the program title in the attendance table (in the shaded area). If the hours fall outside of the program tables starttime and or finishtime an empty...

Thank you very much for you help. All the macros worked.

Thanks for the amendment. Sorry about the confusion for point 3. I was seeking to write the new list next to the old list starting in column D where Column A = "Date", Column B="Activity" Column C is a GAP so that Column D would be the transposed "Date" Column E the transposed "Activity"...

Hi Nebu, Thank you very much for your quick response. The worked. Could you tell me how the code can be changed so that (a) the new list overwrites the old list (b) the new list is written to a new sheet (c) the new list is written next to the old list (with one column gap) Thanking you...

I have a 2 column list of mixed items which include date and details of activity Date Activity 1st January 2015 Activity 2nd January 2015 Activity 1,Activity 2, Activity 3 3rd January 2015 Activity 4th January 2015 Activity 4th January 2015 Activity 4, Activity 5,Activity 6, Activity 7 a)...

Hi Narayan & Mike Thanks for the feedback. The yellow rows were just for illustration. I have looked at the file Narayan sent and am till trying to understand how the array formula is written and the logical behind it.. The formula seems to be working for test scores or marks that are...

Hi Hui, the rating will be determined by the test score. Each student will be taking a grade specific tests but if their test results is higher or lower than the scores predetermined for their grade they will be graded according to the next grade range if the test score is higher or lower. I...

I am trying to perform a grade referencing task and not sure if i need to perform a reverse lookup on a grade score table. I have a test score and student class grade. I am struggling with a formula to check the students test grade is associated with their grade level either higher or at...

Hi NARAYANK991, Thanks to you for your explanation and everyone for the assistance and the help in resolving this.

Hi NARAYANK991 I did check the file and it does achieve the outcome i was seeking. It would be helpful if you could advise me of how it works. I am still puzzled about how the OR(AND()) function was working and is supposed to work. Have I missed understeed that OR(AND(1)..(AND(6)) should...

Hi NARAYANK991 Thank you for the reply and the links which you have suggested. I had checked some of these already for solutions but have yet to find one. I think the logic of the problem is fairly straightforward and if I could figure out the solution to the comparing and matching of the...

Hi Hui Xcelsius produces a dashboard that is driven by an imported excel worksheet - it recognises some but not all of excels functions i am discovering that in this instance when trying to work with arrays Xcelsius does not recognise the calculations generated by these formulaes (ie the...

Hi NARAYANK991 Thanks for your reply. The list is a list of functions that DO work with Xcelsius. But the SUMPRODUCT , SUM , VLOOKUP , HLOOKUP functions when used for arrays do not return dynamic results in Xcelsius which is what i am trying to achieve - the use of these functions...

Hi deb, thanks for the reply, unfortunately this only works if its a 3 criteria search and i am expecting searches that range from 1,2,3 4 and any combination of cells

Hi shrivallabha Thanks for your reply, Unfortunately Xcelsius does not accept the ROW or does allow array functions the use of sum, sumproduct and CSE formulaes the functions that it recognizes are below. is there any way to adapt the formulue so that it does the following 1) checks to...

i was thinking that the only solution was to add a lookup column that matches the criteria selected using the logical operators but cant figure out how to filter only for the criteria selected

none of the sumproduct sum vlookup functions or any CSE forumula will work in Xcelsius

Hi NARAYANK991 thanks for the reply, I am using the excel spreadsheet for and xcelsius 4.5 dashboard and it does not support the array functions of excel i am really limited to solutions that use match and index functions I really need a non array solution

Hi Indian thanks for the reply just learned how to upload the example I hope the link works https://www.dropbox.com/s/zrjf0wjj77ligf5/SampleData%209703a.xls

=OR(AND(D3=$I$3,E3=$J$3),AND(D3=$I$3,F3=$K$3),AND(D3=$I$3,F3=$K$3),AND(E3=$J$3,F3=$K$3),AND(E3=$J$3,G3=$L$3),AND(F3=$K$3,G3=$L$3)) I am trying to filter all 2 criteria combinations of a 4 criteria table I am not sure why this returns true when three cells are selected - is there any way this...

hey hui thanks for your reply. I really need to try and achieve the outcome of the advanced filter with a formula that I can use with Xcelsius. I really need a non array based formula for a lookup column that will allow firstly to determine how many criteria (between 1-4 and any...

I am trying to adapt a sheet http://www.youtube.com/watch?v=SiaTyBcvj8I for an xcelsius dashboard so that it can extract data from a list based on any combination of 4 criteria (ie extract data using any single criteri, or any combination of 2 criteria or any combination of 3 criteria amd...