Search array retrieve data

Advanced search
In
39 results in the forums
Order by date - Order by pertinence
All (68)
Press (29)
High-tech (39)
 
Excel array truncates data
Can someone more intelligent than me help with this? I'm using the following array to match firstname, surname and set and retrieve some data as a result: =INDEX('[ICT GCSE.xls]2011'!BR$4:BR$92,MATCH(1,('[ICT GCSE.xls]2011'!$C ...
Message posted on the January 4th, 2011 - 3:16 PM ET
getting info from array but not using column / row numbers
i need to get info from table: Dist / Age 12 13 14 15 100 1.4 2.0 3.0 4.0 200 1.3 2.1 3.1 4.2 300 1.5 2.2 3.2 4.4 400 1.6 2.3 3.4 3.4 So, if i needed to get data for a 14 year old where ...
Message posted on the March 23rd, 2010 - 12:18 pm ET
Lookup / Array Range / find the value
I have seen similiar examples but not that were not using exact matches to retrieve data. This seems simple and maybe I am over thinking but I have been unable to crack this nut. I have a table where the first tier sales runs between 0 and 20k and ...
Message posted on the May 18th, 2010 - 12:25 am ET
Stubborn Array won't Populate from single ADODB.Connection Query
I previously posted that I could not figure out how to populate VBA Variables from ADODB.Connection results. I was able to get some help on figuring that out. That time I was running multiple queries that each had only one result returned, so I ...
Message posted on the August 25th, 2009 - 02:54 am ET
Passing Array Values to a Sub
I have a UserForm that contains functionality to collected multiple sets of data points for similar things; e.g. the details of parties to a contract or the details of rented goods. I collect the information in an array, which is declared as Public ...
Message posted on the July 31st, 2009 - 12:28 am ET
using a array in access
i wish to use a 3 damential array to enter data form a form add to the data at a later date search the first 2 dimansions for a match retrieve the data from all the denentions and display it in form or list box
Message posted on the January 02nd, 2010 - 03:38 am ET
VB6 Expected Array error
Hello all! I am a newbie VB6 programmer. This part of my program is going to the SQL server to get data and then taking that data and entering it into an Excel spreadsheet. (Excel 2003) I am getting an "expected array" compile error on ...
Message posted on the July 29th, 2009 - 09:51 am ET
Looking Up Two Values in an Array
Here is my situation: I am trying to compare the values I enter (width, height), compare them to a table and retrieve a value in an associated third column. So the question is, with these two dimensions (width 4.25, height 2) what index value will ...
Message posted on the January 04th, 2009 - 10:31 pm ET
SBS 2003 SP2 - ML350freezing and Event ID 7011
Hi, We have a SBS 2003 server that has some serious issues for few weeks now. The problem is that server freezes for a short span of time and comes back to life. Freeze happens many times every hour and lasts 50-60 secs each time and then come back ...
Message posted on the June 23rd, 2010 - 07:30 am ET
Bug#677164: wacom: Try to fix regressions in 3.2.18-1
Hi Ben, The attached changes are extracted from the commit at the tip of git://linuxwacom.git.sourceforge.net/gitroot/linuxwacom/input-wacom According to upstream, Thinkpad x220t (0xE6) hardware reports too high a maximum number of touch points. ...
Message posted on the June 25th, 2012 - 01:30 am ET
[PATCH] usb: cp210x: Update to support CP2105 and multiple interface devices
OS/Kernel version: GNU/Linux 3.3-rc4 (Mainline) Description: This patch updates the cp210x driver to support CP210x multiple interface devices devices from Silicon Labs. The existing driver always sends control requests to interface 0, which is ...
Message posted on the February 23rd, 2012 - 05:10 pm ET
[PATCH 2/2] Input: Add EVIOC mechanism for MT slots
This patch adds the ability to extract MT slot data via a new ioctl, EVIOCGMTSLOTS. The function returns an array of slot values for the specified ABS_MT event type. Example of user space usage: struct { struct input_mt_request req; int ...
Message posted on the January 12th, 2012 - 02:30 pm ET
[PATCH 3/3] [RFC] ipc/sem.c: replace busy loop with completion
ipc/sem.c uses a custom busy loop to handle a rare race and short race condition (typically the loop is shorter than one wake_up_process()). Unfortunately this loop is broken on -rt, thus this patch converts the code to use a completion instead. ...
Message posted on the September 24th, 2011 - 01:40 pm ET
Linux 3.6-rc6
Ok, another week, another -rc. And as I suspected, the reason -rc5 was so small was that a lot of people were still getting ready after the Kernel Summit. So -rc6 is a bit larger, since people were playing catch-up. That said, it's not *huge* ...
Message posted on the September 16th, 2012 - 07:10 pm ET