Finding a value within two different ranges
I need a formula that will do the following. I have a report that shows time intervals in column A and number of calls in column B. I need the start time and end time of the ranges of time where the calls exceed 30. So for the spreadsheet that I attached I would need the formulas to return 8:30 AM-11:00 AM, 12:30 PM-2:30 PM, and 3:30 PM-5:00 PM.
I have a table and I'm having the hardest time trying to find a function that will allow me to enter in a value and have it return the points listed. So for example if I type in .25 in a cell I would like it to return 100. or if I typed 1.30 it should return 250.
I have tried VLookup but I obviously am not doing it correctly if that is the function that I need to use. Thanks for any help that I receive.
I have like 300 columns with 50 values in each and I want to find duplicates across these groups - e.g. number 23,5366 appears in group no. 23, in group no. 45, in group no. 145 twice, etc. - and I need to get back the row reference of these duplicates ( conditional highlighting would suffice). How can I achieve this?
I am having trouble trying to count and add up the number of cells that do not match between ranges. This is what I have right now:
Of course, the problem I am having is when I put the "" in, it turns my B2:E6 range into text. I am sure there is an easy solution to this (I hope) but I am having a tough time finding any info on it.
I'm trying to find the week end date using Fridays as the end of the week from a list that has the actual date work was done for items 1-12. The dates need to be with in the range specified at the top. Basically if the actual dates for work done for items 1-12 from the date table below fall into the specified range, the Friday end date of that week the work was done would appear in the table above and everything outside the range would remain blank. I've attached an very basic example. I imagine I would need to use some sort of Vlookup that looked at the table below to match the item number to the date and then if that date fell into the data range it would change the date to the Friday of that week.
Related Applications & Scripts
This clock is taking the time off your local computer and displaying it on the web page through Flash. This is not perfect as I don't know if your clock is correct. There are other ways of finding out the time but they are much more complicated and not necessarily more accurate. So I have gone for a very simple method of finding out the time. It works and is not too difficult to create.
Random-loading graphics to amuse your viewers. Easily select which graphic or even the colors to use by simply indicating in the code. You can also tweak the random scale & rotate ranges. Fullscreen ready. Aligns to center stage.
Free tool that shows the location of IP address, domain or hostname. It uses Maxmind GeoLite city database for the purpose of finding IP location) and Google maps API for creating the world map.
Looping animation of a confused hectic girl, keep digging and throwing all the stuffs to find the right thing she want. Perfect to illustrate a messed up situation, when someone in a hurry but things are so unsupporting. Its like finding a needle in a hay stack, oh gosh.
It is a frame by frame animation, the file contains various sprites to build the whole animation. In case you need only one pose for a presentation, you can easily copy the sprite from the timeline and use it like the way you want.