|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Huge table needs to link rows and column in a special manner (when not equal to 0)
please see attachment
So, I want to know my couple when the cell is not equal to 0, so I get to know what is my OTU and its identity. I would like to have 3 columns telling me, example: OTU_3 = #ITS2_A_B10_VG6RM_00284_01321 and that I have 8857 copies of it. How do I do this, since my table is reaaally big. Thanks |
#2
|
|||
|
|||
Could you attach an abbreviated version, say the first 10 rows, of the file?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
need a shortcut for paste special link unformatted text | noetic76 | Word VBA | 2 | 06-29-2014 06:40 PM |
Referencing rows of a table at a bookmarked location based on the value of a column | jpb103 | Word VBA | 11 | 05-22-2014 08:33 AM |
Group Table Rows/Column (like Excel Group) | eoinymc | Word | 1 | 03-11-2014 04:51 AM |
Make row in one sheet equal column of another | hypertyper | Excel | 6 | 01-31-2012 03:48 PM |
Paste Special Link no longer working | MrsMoe | PowerPoint | 0 | 12-20-2010 10:54 PM |