Results 1 to 3 of 3

Count in array

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2017
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    24

    Count in array

    Sir

    I have two columns which is Beginning date and Ending date. I am doing calculation to find a number of days in between two days. Some of them are "0 ", some of them are above "1" and some of them are "-1 ".

    I wish to get the result directly to corresponding cells of the tables as per above description ( Blue color ).



    File attached
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help - Dynamically Create an Array, Based on Key Cell, and Count Text within Array
    By mattsmit87 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-30-2017, 03:44 PM
  2. Loop through list, add to Array, count number of occurrences, clear array
    By HalPlz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-11-2016, 09:42 PM
  3. [SOLVED] SUM array works, COUNT array does not?
    By FDibbins in forum Excel General
    Replies: 17
    Last Post: 10-11-2014, 09:11 PM
  4. Help me! I want to count the working days of worker with count and if array.
    By tuyetngapt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2013, 12:52 AM
  5. [SOLVED] Create 1-col array identifying occurrence count in a 1-col array
    By empsall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2013, 12:50 PM
  6. How to count an Array
    By djblois1 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 05-09-2012, 05:26 PM
  7. Array and count
    By selts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2007, 12:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1