The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
38 views

How can I get information from one cell in a row, based on the clue of 2 other cells in the same row?

I'm trying to get Excel to give me information in Column C based on the values in Columns A and B. Cell A and Cell B will contain duplicates, and what I'm trying to do is build a formula which finds ...
1
vote
2answers
71 views

Formula to search highest value related to a near match reference

I have a list of neutral references which change as per the date so What I am looking for is a formula that will search Product and return the latest date. e.g., A B ...
0
votes
2answers
195 views

MS Excel using multidimensional lookup

Hi am trying to assign a value given that if I have a some value that matches column 1, it will search try to check if for that specific row my my product variable is lesser than specified. So let's ...
0
votes
2answers
69 views

Excel look-up column data

I have two data tabs for survey responses - the first shows the full set of exepcted responses an which office they are from HMIP LDU 1 Leeds 2 Leeds 3 Leeds 4 Leeds 5 Wakefield ...
0
votes
2answers
162 views

Camera control box plugged into the router, any idea how I can find its IP?

In the past I've used it but recently I got a new router. I plugged the camera control box in, and it has an internal webserver to configure it. However I just have no idea what its IP address is. I ...
0
votes
1answer
20 views

Looking up the row number of a shared identifier in Excel, and counting the number of cells in that row that meet specific criteria?

I have a sheet that contains a lookup value in columns. I want Excel to look for each value in another sheet, and count the number of instances of a certain word in the row in which it found that ...
0
votes
1answer
1k views

How to automatically populate a lookup column in Sharepoint 2013

I have 2 Sharepoint lists in SP2013: Errors and Locations. The errors list has a lookup column to the locations list. I need the location information (phone, address, etc) to populate automatically ...
-1
votes
1answer
33 views

Finding the largest value in a 2-dimensional range and returning the column header

I've been struggling to find a solution to locating the maximal number within a 2-dimensional range and then looking up the column header that the maximal number falls into. For example: I'm ...
1
vote
0answers
35 views

Trouble adding values from different ranges in excel

I have a fairly unique problem I am having trouble with. Essentially, I need to fix column U on Sheet 1. Ignore stuff out of the tables, as most of that is stuff I either will hide but reference, or ...
0
votes
0answers
41 views

How to force Lync 2013 to lookup within local Contact List first and then perform a remote search?

In MS Lync 2013, everytime I type a name in ("Find Someone") textfield, Lync will bring results by querying server only, why? if that name is already added in my Contacts/Favorites List locally, it ...
0
votes
0answers
29 views

Domain name lookup as another domain name

In Windows (8.1) hosts file contains mappings of IP addresses to host names. For example: 127.0.0.1 example.domain.net What I want to achieve is to map a domain name to another domain ...
0
votes
0answers
8 views

Alternative DOI resolvers besides dx.doi.org?

http://dx.doi.org/ is frequently slow for me. Are there any alternative DOI resolvers? thanks