Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code or formula needed to identify certain records in a database
I'm drawing a blank on this one.
I have an Excel database made up of 24 columns (representing numeric fields) and approximately 2500 rows. Each record will have a value in at least one of the 24 fields and can have values in up to all 24 fields. I am to create a 25th field (called "ID") in which an "x" is placed if a record meets the following criteria: 1.) It must have values in at least 2 of the 24 fields, and 2.) At least 1 of the fields with a value in it is not contiguous with another field with a value in it. In other words, to qualify for an "x", at least 2 fields have numbers and there is a gap separating at least one of those fields. Here's a simplified version: Field1 Field2 Field3 Field4 Field5 ID ------------------------------------------ 12 ------------------------------------------ 3 14 x ------------------------------------------ 1 5 ------------------------------------------ 7 8 12 x ------------------------------------------ 2 3 ------------------------------------------ 6 5 4 x ------------------------------------------ 8 7 1 12 14 ------------------------------------------ 7 8 10 11 x ------------------------------------------ Either a macro solution or a formula solution to getting the "x" is fine, and if "helper" columns are needed, that's fine, too. Many thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro needed to identify value and delete row if value below targe | New Users to Excel | |||
How to identify when similar records appear in two sets of data | Excel Discussion (Misc queries) | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
compare two spreadsheets and identify records that have any change | Excel Discussion (Misc queries) | |||
formula / code help needed | Excel Discussion (Misc queries) |