#### Find data in two ranges

```Hello,
I have a worksheet with in the same row two different ranges:
one with nummeric data
one with time values.
These two ranges works as follow the first nummeric data cooresponds with
the first time value, the second nummeric data corresponds with the second
time value.
For the nummerric data I calculated the best of 3.
Now I need the corresponding time value for those best of 3.
Thanks for your help with this one.
```
 0
Utf
12/5/2009 8:57:01 PM
excel.worksheet.functions 4936 articles. 2 followers.

2 Replies
555 Views

Similar Articles

[PageSpeed] 33

```Someone replied to your other post and asked for more detail.

--
Biff
Microsoft Excel MVP

"Santafe" <Santafe@discussions.microsoft.com> wrote in message
> Hello,
> I have a worksheet with in the same row two different ranges:
> one with nummeric data
> one with time values.
> These two ranges works as follow the first nummeric data cooresponds with
> the first time value, the second nummeric data corresponds with the second
> time value.
> For the nummerric data I calculated the best of 3.
> Now I need the corresponding time value for those best of 3.
> Thanks for your help with this one.

```
 0
T
12/5/2009 9:54:54 PM
```Thanks, I am new to this and I wasn't aware of this second post.
I dit get an answer in the other post and the problem is solved.

Thanks.

"T. Valko" wrote:

> Someone replied to your other post and asked for more detail.
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Santafe" <Santafe@discussions.microsoft.com> wrote in message
> > Hello,
> > I have a worksheet with in the same row two different ranges:
> > one with nummeric data
> > one with time values.
> > These two ranges works as follow the first nummeric data cooresponds with
> > the first time value, the second nummeric data corresponds with the second
> > time value.
> > For the nummerric data I calculated the best of 3.
> > Now I need the corresponding time value for those best of 3.
> > Thanks for your help with this one.
>
>
> .
>
```
 0
Utf
12/6/2009 2:37:01 PM

Similar Artilces:

cant find report
Hello all I can't seem to find the "detail Historical Aged trial Balance" report. We just upgraded and I this is not a modified report so security should not be a problem wondering if anyone knows if this report has moved?? TIA Hi Brian, Isn't that the "RM Detail Historical Aged Trial Balance" ? It may have changed it's name ... Beat -- +-+-+-+-+-+-+-+ B. Bucher Dynamics GP 10 Sr. Sys Admin www.fti-ibis.com +-+-+-+-+-+-+-+ "Brian" <nixtootec@hotmail.com> wrote in message news:euVaJPfcKHA.2188@TK2MSFTNGP04.phx.gbl... >...

How do I calculate the # of business days between two dates?
I know absolutely nothing about coding. Trying to use calculations in a report or query to accomplish this. Everything else I have found seems to include "coding" that goes way beyond my capabilities. Anything a novice can use? You need to use code: http://support.microsoft.com/kb/97757 You can call this function in a query 1. make the function a Public Function In the query have a column like this WorkDaysCalc: Work_Days([StartDate],[EndDate]) where [StartDate] and [EndDate] are actual fields in your query. Everyone starts out a "Novice" but the m...

Importing data #5
Hello, I have a workbook in Excel 2003 that I need some advice on please. The data used in the spreadsheet is collected online into a CSV file, this CSV file is imported into Excel onto a "Raw Data" worksheet. From this raw data several other worksheets need to access this raw data to prepare the reports required. I have the first report sheet designed and it picks up the data from the Raw Data sheet. The problem I need help with is updating the raw data; when I download a new file from our web site and refresh the data import the report worksheet does not update correctly. Fo...

Append Query
I have a table "Rates" with the following data: StartDate: 5/15/08 End Date: 6/23/08 Rate: \$53 StartDate: 6/24/08 End Date: 7/15/08 Rate: \$86 StartDate: 7/16/08 EndDate: 9/19/08 Rate: \$99 I have another table "Transactions". I want to create an append query such that if I supply the StartDate and EndDate, the query will populate the "Transactons" table with date and rate data from the "Rates" table for each and every day within the date range. Example: If I supply the StartDate of 6/23/08 and the EndDate of 6/25/08, the query would pop...

How to combine/consolidate data
Hi, I am about to create an Excel file that should be used by custmers to place orders. On the first sheet, I would like to have a summary of the entire order, so the customer can see what he ordered. All data is organized in same sort of tables accross several sheets - each sheet representing different product group. So, lets say I have table organized like below: ColumnA ColumnB ColumnC Product Price Order Prod1 10 1 Prod2 20 Prod3 20 2 And I have several of such tables on different sheets corresponding to each prodcut category. Now, on the first sheet, I w...

Traspose Column data into Row
Hi, I want to transpose column data in to row. I have seen many posts (using INDEX or OFFSET functions) but all these solution assume a fixed block of data to be transposed, My problem is that the data i have not only has variable blocks to be transposed but also has some duplicate headings(headings are duplicate but the data in front of each heading has different value. Below is the example of data Col A Col B Col C PRODUCT COST COMPONENT COST\$ A Raw Mat 10 A D L ...

Analysing data from several excel workbooks
Hi, I'm totally new to excel and i need to analyse the changes in a funding position across several years in a seperate excel sheet. As in, submissions are made year on year showing the amount of revenue spent on several different services. I need to be able to compare how those have moved over the last 5 years in a single spreadsheet. I appreciate any help. Thanks To give a clear answer we would need a bit more detail of the data layout Give us a simplified version of what the data looks like Your 'subject' talks about different workBOOKS but the text of the ...

Conditional Formatting
I have a row of cells that calculate the totals for their columns but I force to be blank via IF statements until certain conditions are met. Once these conditions are met, the total appears. I'd like to also highlight these total cells via conditional formatting. My conditional formatting input is simply "If Cell is Greater than 0, format". For some reason all the cells format as though they are all > 0 yet they don't display anything. Are there some internal rules that specifiy when a cell is really 0? Is there another way to do this that won't care what the for...

Dynamic Named Ranges
I have a chart which displays 30 days worth of data at a time, linked to another workbook. I am charting a dynamic named range in the source file however my chart data disappears every time source workbook is closed (not cool!) need a way around this without using macros.. Apprceiate any help ...

recovering data
Money 2000: Is there a way to recover data that was not backed up. I accidently deleted all deposits. When I used the restore file procedure all saved deposits were restored, but all deposits and withdrawals that hadn't been backed up were deleted. How can I get that work back? Thanks! Retype it all? I mean, seriously, if you type three pages to a document in Word that you last backed up a month ago, delete the three pages and then quit Word where are you? "ETHORN" <anonymous@discussions.microsoft.com> wrote in message news:e40d01c3f101\$8989da00\$a101280a@phx.gbl...

Managing Data Table
Hi, I need help to wrap the tex in Data Table. If any one knows how to do it, please let me know. Thanks for your help in advance. Yogesh Hi Yogesh What version of PowerPoint are you using? What kind of table is it and how did it get there (e.g. insert -> table, or a table connected with a graph)? If it's a graph, is it an Excel graph or an MSGraph graph? Lucy -- Lucy Thomson PowerPoint MVP MOS Master Instructor www.aneasiertomorrow.com.au "Yogesh" <Yogesh@discussions.microsoft.com> wrote in message news:F68FDA89-6289-4341-8886-54C580...

Can't find CD/DVDdrive
My DVD drives have disappeared. they don't show as hardware in control panel. Working fine yesterday - no software changes made. Both have power to them. I've unplugged everything and put a new lead from them to the motherboard. Doesn't appear to be anything physical. Followed various posts on this site. Mr Fixit recognises the problem but can't fix it. Went into registry. Higher filters there but no lower filters. Any suggestions? On 06/20/2010 05:13 AM, Philx5 wrote: > My DVD drives have disappeared. they don't show as hardware in control panel. ...

Question with local vs. remote (Exchange server) data
Can someone please explain something basic to me about the way Outlook works. I'm a Mac user and not familiar with this thing but now need to figure out how to synchronize it with a PocketPC PDA device. We've got Outlook on our PCs (W2K), connected to an Exchange server. So, I see my calendar and contacts, which I know live on the server. But when I sync my device, it ends up empty. Is there some sort of "local" (to my PC) data that it's using instead of the Exchange server's info? If so, where is it and how do I find it? If I could find it, I could copy the Exchan...

"Find an event" feature in the Windows Live Mail/Calendar
In the Windows Live mail it is quite simple to "Find a message" as we type something in the search box and enter. But, I do not see any search box with the Calendar. Are there any ways to "Find" something in the Windows Live Calendar? Looking forward to hear from someone. Thank you. ...

Bytes in Data Page Row
I am reading a book titled "Microsoft SQL Server 2008 Internals". In Chapter 6, which was authored by Kalen Delaney, Kimberly Tripp, and Paul Randall, the following table and Clustered Index is created: CREATE TABLE Employee( EmployeeID INT NOT NULL IDENTITY, LastName NCHAR(30) NOT NULL, FirstName NCHAR(29) NOT NULL, MiddleInitial NCHAR(1) NULL, SSN CHAR(11) NOT NULL, OtherColumns CHAR(258) NOT NULL DEFAULT 'Junk') GO ALTER TABLE Employee ADD CONSTRAINT EmployeePK PRIMARY KEY CLUSTERED (EmployeeID) GO It states on page 321 of the aforementione...

data import and word templates missing from CRM
Hi. I'm working with a new install of CRM and there are some icons missing in the setttings area such as the import function on the data management page and word templates under templates. Any ideas about why this is? Thanks. ...

how to create row with data
imagine i have two rows: name and color: mary blue ken brown will blue what i want is having, in another row, just the names that have blue eyes, like mary will thank you On Mon, 11 May 2009 17:26:04 -0700, rafael <rafael@discussions.microsoft.com> wrote: >imagine i have two rows: name and color: >mary blue >ken brown >will blue > >what i want is having, in another row, just the names that have blue eyes, >like >mary >will Like: mary will or like: mary will ???? ty i have excel 2000 what i want is all names in a single row, wi...

How can I get data from an entity via java script
How can I get data from an entity via java The problem: I have a new entity with alle zipcodes and cities/countries. I want it to be so that if a person enters data in the zip code on account or contact that city and state automatically is filled with corresponding data from the new zip code entity. How can I do this, java script ?` Any ideas appriciated ! Jack -------------------------------------------------------------------------------- Jeg beskyttes af den gratis SPAMfighter til privatbrugere. Den har indtil videre sparet mig for at f� 13991 spam-mails Betalende brugere f�r ikke de...

Data type on import wizard not active
Hi there, Hopefully, someone can help me with this. I'm using the importing an excel 2003 into access 2003. Using the import wizard to import the excel 2003 spreadsheet. everything is fine until i get to the field options: dialog box. The Data type drop down isn't active. What can i do to make this drop down option active. Thanks for your help This is a known issue for ACCESS 2002 SP3. This issue is described in http://support.microsoft.com/default.aspx?scid=kb;en-us;875252 There is a Hotfix available for ACCESS 2002 from Microsoft Technical Support for this problem. Descr...

how can we transfer data from child dialog box to parent Dialog Box. #2
hi guys, i have created modalless child dialog box by parent dialogbox using UI Thread . now i want to do 2 things first i want to transfer CPoint variable from child to parent and second i want to call OnLButtonDown() function of parent DialogBox. i have hint but not proper please help me to complete this one. SendMessage(m_pParent, WM_LBUTTONDOWN, x,y); // from child side void CHRS_MoleDlg::OnLButtonDown(UINT nFlags, CPoint point) //on parent dialog box first of all tell me is it possible if yes then what will be "x" and "y" so that they can convert into CPoint v...

Message-Data file not properly closed???
Upon boot of Outlook, EVERYTIME, I get this message--Data file did not close properly the last time it was used and is being checked for problems. Performance might be affected by the check in progress. When I leave Outlook, I have made sure to close all files and exit properly. Is there some reason this happens? I even go back to my main screen now. Is there something more I should be doing. Did the file checking finish before you closed Outlook? If not, it will continue/restart the next time you start Outlook. If it still does this after the checking has completed, the...

Data Entry to a Cell Range
Can I set up a data entry form, so if every time I enter a value in a cell, it updates the next empty cell in a range? Thanks Lets assume that the form is used to update cell A1. We require that everytime A1 is updated the new value will be recorded in column B. Put the following event macro in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) Dim A1 As Range, t As Range Set A1 = Range("A1") Set t = Target If Intersect(A1, t) Is Nothing Then Exit Sub Application.EnableEvents = False n = Cells(Rows.Count, "B").End(xlUp).Row...

Comparing data
There are 2 column in this query:- Column 1 Column 2 A A B C C E D D I want this 2 column to compare. If both A, display A, if different compare next 1...However, the result of the third column will give me all A,C,D without B and E included at the last row? Any idea to make them show all A,C,D,B,E? -- Message posted via http://www.accessmonster.com On Mon, 21 May 2007 02:19:56 GMT, "EMILYTAN via AccessMonster.com" <u33296@uwe> wrote: >There are 2 column in this query:- > >...

Increase data type size in GP table?
I don't know whether this is supported or not, but we're planning to roll out the HR module on GP9, and one of the fields that is missing for job applicants is an email address. We'd like to use an extra field to hold this data, but the field length is too short to adequately contain that information. I'm wondering if I can change the length defined in the SQL table structure for that particular column, or, if doing so will likely mess up something else (stored procedures, mappings, etc.). Any thoughts? Thanks in advance! Technically, yes. However, if you do that, you...

Error in Data Migration Framework (DMF)
Help..... I am trying to upload 14,000 Account records using the Data Migration Framework, along with 6,000 Contact records. It was easier to use the DMF rather than the bulk import especially with the relationships between the records. I first trialled the DMF migration of these records on the May VPC image supplied by MS and it all worked fine. However now that it is being run in a pre-production environment on full sized servers I am having problems. Approximately half of the account records, and all the contact records have been uploaded successfully. Half of the account recor...