+ Reply to Thread
Results 1 to 14 of 14

Faster Way to Substract 2 Columns?

Hybrid View

  1. 01-21-2015, 04:55 PM #1
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: Faster Way to Substract 2 Columns?

    Can you send a short sample of your data, with mine it was OK
    Perhaps try depending of your data
    If ((WkTb1(I, 1) <> "") And (WkTb2(I, 1) <> "")) Then WkTb1(I, 1) = WkTb1(I, 1) - WkTb2(I, 1)
    Attached Files Attached Files
    Last edited by PCI; 01-21-2015 at 04:58 PM.
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Faster way to COUNTIF across multiple columns for datesets over 100,000 rows
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2014, 05:44 PM
  2. [SOLVED] Faster way than deleting columns one by one to reduce my data to the correct columns
    By jcardisco in forum Excel General
    Replies: 12
    Last Post: 01-30-2014, 01:33 AM
  3. [SOLVED] Faster way to copy and paste multiple columns in Sheet1 to corresponding columns in Sheet2
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2013, 12:55 AM
  4. [SOLVED] How do I substract numbers in range like this: Substract(a1..a10)
    By Paulo in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-17-2005, 12:50 AM
  5. Can faster CPU+larger/faster RAM significantly speed up recalulati
    By jmk_li in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 06:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1