Announcement

Collapse
No announcement yet.

Counting cells that have specific value

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • al7abob
    replied
    Works perfectly.. Appreciated

    Leave a comment:


  • charliechaps
    replied
    OK I've done an example for you, it loops thru the Grid rows checks if text in cell if so adds 1 to the count
    CSV GETCount.apz

    It's Basic so you get the idea

    Leave a comment:


  • al7abob
    replied
    Sorry for my late reply,

    The grid imports the data from Excel CSV file
    then I want to check each cell in column 4 (completed date) .. if there is a date then count it
    then replace the total count in label

    1) For now have included
    Grid.LoadFromFile("Grid1", "AutoPlay\\Docs\\1 NON.csv", ",", true);

    in page>on show

    2) I know how to replace the count in label but i dont know how to count the cells that have completed date in column 5

    Leave a comment:


  • daviz
    replied
    can you share your project?

    David Ramirez

    Leave a comment:


  • al7abob
    replied
    Im a biginner .. no idea how to use for loop and count the cells

    Leave a comment:


  • daviz
    replied
    Have you tried with a for loop?

    David Ramirez

    Leave a comment:


  • al7abob
    started a topic Counting cells that have specific value

    Counting cells that have specific value

    Hi there,

    Im working on a grid table where I have a table with data .. I want to count the cells that have specific value example "DONE"

    Similar to function "COUNTIF" In Excel .. I have searched alot in the forum but couldn't find any

    Waiting for your reply
Working...
X