Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy list only with values?
I have a table with names (col A) and values (col B). I am trying to create a
table using col C and D to list te names and values from table1 that only have a value. ie Name Value Name Value Jim 9 Jim 9 Joe Joe 1 sue 1 Ant 5 Ant 5 Bill 3 Hill Bill 3 This table will change on a daily bases. Can anyone help!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy list only with values?
Have you looked at Data | Filter | AutoFilter
-- HTH... Jim Thomlinson "hoyos" wrote: I have a table with names (col A) and values (col B). I am trying to create a table using col C and D to list te names and values from table1 that only have a value. ie Name Value Name Value Jim 9 Jim 9 Joe Joe 1 sue 1 Ant 5 Ant 5 Bill 3 Hill Bill 3 This table will change on a daily bases. Can anyone help!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy list only with values?
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy list only with values?
I tried that formular but I get #NAME indication in the cell?
"Bernd P" wrote: Hello, I suggest to use my UDF Pstat: http://sulprobil.com/html/pstat.html Regards, Bernd |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy list only with values?
Hello,
Which formula did you array-enter exactly? Regards, Bernd |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy list only with values?
I tried this one:
Pstat("min" "Bernd P" wrote: Hello, Which formula did you array-enter exactly? Regards, Bernd |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy list only with values?
Hello,
Did you press ALT + F11, insert a new module, copy my macro into that new module and go back to your worksheet? If yes, how EXACTLY does your formula look like (please show the complete formula)? Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions |