Extracting data from a list without duplicate (repeating entry)
Hi Community, I need help with my template creation with regards to extracting data from another sheet with multiple criteria. I hope somebody could provide solution to my problem. On the file attached, sheet2 contains the raw data and sheet1 serves as the summary. My problem is on how to retrieve all the discipline, role, level, hourly rates without repetition due to different values in working hours, days, quantity. Right now it retrieves all the entry as long as it is unique in terms of the whole row. Here is the snap shot of the summary but I would like to retrieve instead. Basically it should retrieve only one entry for discipline, role, level and rate and calculate the rest for the hours, days and fee.
How to get the highest value PER name in list?
I have a list of names. A person can appear several times in column a. Column B has the check in time (all different for each name instance). Column C has the check out time (again, all different). How can I request the earliest and latest check in/out time per person? (Column C and D) This data is for one day.2 lists, 1 if
Hi everyone. I'm trying to create such an IF command, that if a certain cell is empty, nothing happens, if it has lets say "1" a certain list prepaired earlier appears, if "2" a different list appears. When attempting to perform the command =IF(A1="";"";IF(A1=1;list1;list2)). I don't have to consider other possibilities other than these 3. When I imput this formula, if A1 is empty, no list appears, which is good, but if I imput an other value (correct for the formula or not) it immediatly creates "list2" Additional question, is it possible, to create a counter of amount of appearences in the program. Lets say the above formula, or corrected by you, works. I'll have a few people listed and because depending on the date and localization that the person appears/will appear, can I set a counter, that will not print, but count the amount of dates "John" or "Sally" appeare in the calendar, even thos, the information is being sent from a list? Thanks
