Huge table needs to link rows and column in a special manner (when not equal to 0)

		Microsoft Office Forums > Microsoft Excel > Excel
Huge table needs to link rows and column in a special manner (when not equal to 0)

FAQ

Mark Forums Read

Thread Tools

Display Modes

08-11-2014, 11:55 AM

melieetnala melieetnala is offline

Windows XP Huge table needs to link rows and column in a special manner (when not equal to 0)

Office 2010 32bit

Novice

Join Date: Aug 2014

Posts: 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

Attached Images

otutable.png (10.6 KB, 13 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:33 PM.