Excel - Fill column in list based on criteria
Closed
asc
-
15 Oct 2010 à 19:03
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 13 Dec 2011 à 10:46
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 13 Dec 2011 à 10:46
Related:
- Excel - Fill column in list based on criteria
- Excel column number - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Counter strike 1.6 cheats list - Guide
- Arrow keys not working in excel - Guide
- Epic games free games list - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
16 Oct 2010 à 21:08
16 Oct 2010 à 21:08
suppose your data is some thing like this from A1 down
aaasd
aaasd
aaasdfg
bbb
bbbbb
bbbk
ccccc
ccccc
xxxxx
xxxxx
yyyaa
zzzer
zzz
then in B1 copy this formula
=IF(OR(ISNUMBER(SEARCH("aaa",A1)),ISNUMBER(SEARCH("bbb",A1)),ISNUMBER(SEARCH("ccc",A1))),"A",IF(OR(ISNUMBER(SEARCH("xxx",A1)),ISNUMBER(SEARCH("yyy",A1)),ISNUMBER(SEARCH("zzz",A1))),"B",""))
copy B1 down as long as data is there in A.
aaasd
aaasd
aaasdfg
bbb
bbbbb
bbbk
ccccc
ccccc
xxxxx
xxxxx
yyyaa
zzzer
zzz
then in B1 copy this formula
=IF(OR(ISNUMBER(SEARCH("aaa",A1)),ISNUMBER(SEARCH("bbb",A1)),ISNUMBER(SEARCH("ccc",A1))),"A",IF(OR(ISNUMBER(SEARCH("xxx",A1)),ISNUMBER(SEARCH("yyy",A1)),ISNUMBER(SEARCH("zzz",A1))),"B",""))
copy B1 down as long as data is there in A.
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
13 Dec 2011 à 10:46
13 Dec 2011 à 10:46
I think you may have to write a macro. But anyhow if the data is huge there will be problem of overflow. how huge do you expect . you have to separate the criteria.
if you post a sheet with aleast ten critera in each cateogry. some thling can be attempted. use speedyshare.com to upload the file and give the web page for downloading.
if you post a sheet with aleast ten critera in each cateogry. some thling can be attempted. use speedyshare.com to upload the file and give the web page for downloading.