Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2014, 11:55 AM
melieetnala melieetnala is offline Huge table needs to link rows and column in a special manner (when not equal to 0) Windows XP Huge table needs to link rows and column in a special manner (when not equal to 0) Office 2010 32bit
Novice
Huge table needs to link rows and column in a special manner (when not equal to 0)
 
Join Date: Aug 2014
Posts: 1
melieetnala is on a distinguished road
Default 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
File Type: png otutable.png (10.6 KB, 11 views)
Reply With Quote
  #2  
Old 08-12-2014, 05:56 AM
gebobs gebobs is offline Huge table needs to link rows and column in a special manner (when not equal to 0) Windows 7 64bit Huge table needs to link rows and column in a special manner (when not equal to 0) Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Could you attach an abbreviated version, say the first 10 rows, of the file?
Reply With Quote
Reply

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
Huge table needs to link rows and column in a special manner (when not equal to 0) 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 06:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft