Results 1 to 10 of 26

Thread: Macro to check values based on certain text

Threaded View

Howardc Macro to check values based... 10-17-2012, 10:53 PM
Admin @ Howard Please add code... 10-18-2012, 07:56 AM
Admin Hi Try Sub... 10-18-2012, 08:02 AM
Howardc Thanks for the reply. I still... 10-18-2012, 08:36 AM
Admin Hi Is there any error... 10-18-2012, 09:19 AM
Howardc There are two #N/A's, which I... 10-18-2012, 06:11 PM
Admin Hi Replace the error line... 10-18-2012, 07:28 PM
Howardc Thanks for the help-code... 10-18-2012, 08:02 PM
Admin Not sure I understood you... 10-18-2012, 08:28 PM
Howardc Attached please find row of... 10-18-2012, 08:46 PM
Admin hi If... 10-18-2012, 09:13 PM
Howardc Thanks very much for the... 10-18-2012, 10:25 PM
Howardc Hi You helped me a while... 10-31-2012, 03:57 PM
Admin Hi Try If... 10-31-2012, 10:53 PM
Howardc Thanks for the reply. When... 10-31-2012, 11:06 PM
Excel Fox Howardc, what admin has... 11-01-2012, 12:20 AM
Howardc Hi Excelfox Thanks for the... 11-01-2012, 11:06 AM
Admin Hi Howard, Please add... 11-01-2012, 05:38 PM
Howardc Thanks for the help, much... 11-01-2012, 07:11 PM
Howardc Hi Admin I picked up that... 11-04-2012, 12:14 PM
Howardc Hi Admin Attached please... 11-04-2012, 02:22 PM
Admin Hi Just remove the ABS... 11-04-2012, 02:24 PM
Howardc Thanks for the help,I removed... 11-04-2012, 09:01 PM
Admin Hi Use this formula. If... 11-05-2012, 12:16 PM
Howardc Thanks for the help, it would... 11-05-2012, 01:55 PM
Howardc Hi Admin Managed to sort... 11-05-2012, 09:03 PM
Previous Post Previous Post   Next Post Next Post
  1. 11-04-2012, 02:22 PM #21
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14
    Hi Admin

    Attached please find sample data. When activating the macro and there is only one value being a debit in the same row as the text check, it is not shown in the message box. All values that are not zero, except values that are more or less than 5 dicimal places are to be shown-see sample data, B52, which is not shown in message box
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum values based on multiple criteria
    By Jorrg1 in forum Excel Help
    Replies: 8
    Last Post: 01-07-2013, 03:04 PM
  2. Excel Formula To Check If All Characters Are Text Non-Numeric
    By NITIN SHETTY in forum Excel Help
    Replies: 10
    Last Post: 12-10-2012, 11:28 PM
  3. Offset based on Values in Column E
    By mrmmickle1 in forum Excel Help
    Replies: 7
    Last Post: 12-04-2012, 10:06 AM
  4. Macro to clear data based on color fill
    By Howardc in forum Excel Help
    Replies: 7
    Last Post: 12-03-2012, 09:25 AM
  5. Loop and Check For Values In Entire Column in Excel
    By Jeff5019 in forum Excel Help
    Replies: 3
    Last Post: 05-01-2012, 10:34 PM

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