Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get value from Cell (after it is created by CountIF)
I need to be able to import data from one excel sheet to another. Usually I use the following SQL to pull back data from the spreadsheet I want. select count(F14) from [Data spreadsheet$] where F14 = '1' However, now the value that is stored in F14 (the field for which I need for the where clause) is generated from a countif statement: Cell value for rows in F14= COUNTIF(Q1582 : DU1582,"Correct"). In the spreadsheet that I am pulling the data from (Data Spreadsheet), this then puts a 1 if the countif brings back one count. However when I try and pull this back using the following syntax in my query (where F14 = '1') it will not pick it up. So when I do a Select * from the spreadsheet, it is bringing back null values for the F14 column even though they have a '1' in them. So I presume my SQL or settings are not recognising it because it is put in the cell from the countif function. Any help would be great!! Thanks! -- walshy06 ------------------------------------------------------------------------ walshy06's Profile: http://www.excelforum.com/member.php...o&userid=34132 View this thread: http://www.excelforum.com/showthread...hreadid=556038 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get value from Cell (after it is created by CountIF)
Hi, If any one could help with this it would be great as this is urgent! Reached a dead end.. Cheers -- walshy06 ------------------------------------------------------------------------ walshy06's Profile: http://www.excelforum.com/member.php...o&userid=34132 View this thread: http://www.excelforum.com/showthread...hreadid=556038 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get value from Cell (after it is created by CountIF) | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |