e.g

Hi Wondered whether any bright spark out there might be able to advise on this? e.g. if i was looking to say what score (e.g. in a test) a 'top decile' student scored, if the data was like this? <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Score Frequency...

Hi I have searched and found solutions, but none worked with my problem. I have a Column of values E.G. In Column "B" Cell B2 will have 32,57,39. Column A Cell A2 will have a single number E.G. 57. If this is the case, Column C2 should contain "True". I have tried "(--ISNUMBER(SEARCH("...

Hi All, I have a spreadsheet that contains peoples names in a column and different values associated to the person in another column e.g. Wright 1.5 Wright 3 Wright 4.2 Wright 7 Jones 4.6 Jones 2.1 Wilson 9 Wilson 6.7 Wilson 1 Wilson 3.2 Wilson 5 I want to be able to...

Hi there Would really appreciate someones help please. I have the following in a spreadsheet Sheet 1 Col A: contains various numbers in the row e.g 23, 97, 254 etc (then Rows B to H contain various data) A B C D E F...

Hi There! I have set of number ranges e.g 7100 to 7399, 5202 to 5249 etc. I would like to have these ranges split in with each number. For e.g. from the range 7100 to 7399 I would like to have the numbers to split like 7100, 7101, 7102, 7103........7399 Can somebody please help me with this...

Hi there, It's more a general question than purely related to the vlookup function. I am currently able to pull cell data into a worksheet from other workbooks. When I specify the directory in full, the data pulls through: e.g. C:\User\Miscellaneous\Example - 1.xls However, is it possible to...

Hi all, I am a new member to the forum. Need to know how to use IF and MID function together, in order to return a text value: Examples of scenarios below: 1.Gender: Display M (Male) and F (Female). Extract it from a 13-digit ID number( e.g. 6105245137079). The gender is determined by the...

If a user has exceeded their stored private messages quota such that they cannot accept further messages until they clear some space (e.g. a new user who is yet to post to the Forum and therefore has not yet "earned" any quota, but it could be any user with a full mailbox): are they immediately...

Hi guys, I have Peer Group values e.g. 1,4,8,10. I would like all non peer groups records to be ranked by the scale above, e.g. 0.5 to have a rank 1, 9 to have a rank 4 etc. Rank 8 can have rank 3/4, for this purpose it's not crucial. Is there a neat way of doing this?

Hi, I need to pull a number of names where the dates in a corresponding column are greater than today. E.g. <tbody> Column A Column B 1 Name Date 2 Tom 5/4/17 3 Mike 30/6/18 4 Jim 3/3/16 5 Peter 8/1/17 6 Steven 9/11/13 7 Melanie 16/12/17 8 Joe 19/10/14 9 Stephanie 25/9/17...

hi, In A4 i want to sum dynamic number of columns, start from B4 to the right. e.g: B4:E4 e.g: B4:K4 i tried: =SUM(OFFSET($B$4,0,0,3,COUNTA(4:4))) but the formula works in every ceII except A4. 1) why ? 2) Greatful for correct formula. ofer

so I have a flat-file with %'s, obligations over allocations, but when I pivot the data, the totals are off; e.g. they are summing the %'s, not the 2 variables...???

Can someone help me figure this out? I've tried with vloopkup/index match and looked into the Solver add-in but can't find a property solution. I have 5 unit types, each of a certain size (square feet). I have 4 building types each of a certain size as well. For each type of building (e.g...

I HAVE THIS TABLE: <colgroup><col width="149" style="width: 112pt;"> <col width="64" style="width: 48pt;"> <tbody> 2016-01-01 00:00:00 501.1322 2016-01-01 00:15:00 501.1432 2016-01-01 00:30:00 501.1235 2016-01-01 00:45:00 501.1046 2016-01-01 01:00:00...

Hi all I have a number of scattered cells which are NOT in a list or a table e.g. A1, C5, E10, F69. i need to select the lowest value greater than zero without using a long-winded nested if formula. Any ideas? I know this is very straightforward if the cells are in a list or a table because...

Hello, please I need help with one problem. I have currency list for a period and specific dates I need to get the currency for. E.g. A B 24.07.2017 7,4098 kn 21.07.2017 7,4110 kn 20.07.2017 7,4103 kn 19.07.2017 7,4143 kn 13.07.2017 7,4138 kn 11.07.2017 7,4111 kn...

Hi! I'm new to excel. Using the following formula, when searching for single-digit numbers, double-digit number are also found and reverse, e.g. 62 and 26. =IF(ISBLANK($F$1),0,ISNUMBER(SEARCH($F$1,$A1&$B1&$C1&$D1))) How do I modify this formula to search for exact numbers Thanks Jimbo

Hi, for our current project we are limited to adding information in a single cell... so within the cell is there a way 1) to hyperlink only a portion of the cell. E.g., Please refer to https://www.google.com & only https://www.google.com is hyperlinked, and 2) is there a way to add multiple...

Hi I have the current path to clicking a button in a website. is there a way I can define this path to click on, e.g. getelementbyid? $x('//*[@id="header"]//div[text()=" Extract Reports "]') Appreciate anyones help.

I would like to create a pie graph that shows the frequency of the number of times a customer has bought, e.g. how many bought 1 time, how many bought 2 times, etc. The raw information looks like this: The total orders is a calculated measure: Customer Total Orders =...