Calling Cell for name on basis of changing number 0,1.
Closed
Tanveer Ali
-
Nov 12, 2014 at 11:16 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 15, 2014 at 06:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 15, 2014 at 06:55 AM
Dear. I have attendance sheet name "Attendance" of 70 people. having table of their names in 1st Col and Absent in 2nd Col. Absent col changes everyday by 1 or 0 means who absent so 1 come in front of his name and else 0. so I make table of Absent People Name in other sheet renamed "ALL". Now I want that when I enter "1" in Attendance sheet means some one is absent so their name should come in sheet "ALL" where I shows Just absent People. when I enter another "1" in Attendance sheet means now 2 people are absent so its name also come in row 2 of sheet "ALL".
Thanks
Thanks
Related:
- Calling Cell for name on basis of changing number 0,1.
- Change computer name cmd - Guide
- Change name of lg tv - Guide
- How to change number of best friends on snapchat - Guide
- Europe calling code - Guide
- T mobile change number - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 15, 2014 at 06:55 AM
Nov 15, 2014 at 06:55 AM
You can simply filter on 1 and paste the visible rows to all sheet