LinkBack URL
About LinkBacks
Skärmklipp1.PNG
I Want to count every time we make a component switch on the train to make a follow up.
I want to make counter in the column to the right of DATE2.
Hope i could get som help in here
Count every time i change a components ID changes
Skärmklipp1.PNG
I Want to count every time we make a component switch on the train to make a follow up.
I want to make counter in the column to the right of DATE2.
Hope i could get som help in here
Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.
If you need to post an image post it in the *.jpg format.
Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Í´ll post a jpeg. couse it seems i cant upload my example file.
Skärmklipp1.JPG
Ok. Got it uploaded, Excelforum.xlsx
Last edited by ThommyN; 10-02-2016 at 12:39 PM.
Here's your data along with your comment:
Data Range
Show us what results you expect.I wish to count every time i change Component ID
I'll try to explain it.
I work with a train fleet in sweden.
Lets say i switch a component with an uniqe ID, on the train.
Then i enter the new uniqe ID. When i do that i want excel to count that switch. Is that possible?
Originally Posted by Tony Valko
Still not following you.
That's why I asked:
Show us what results you expect.
Ok. Lets se if my example file is helping :P
Excelforum2.xlsx
I need the changes to be logged.
Sorry, I don't understand what you're wanting to do.
My vba is not so good but take al look at this:
http://stackoverflow.com/questions/2...rent-worksheet
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
First thing will be to change the formatting on column K from 'Text' to 'General'.
Paste the following array entered formula* in K13 and activate by pressing Ctrl, Shift and Enter Simultaneously:Formula:
Please Login or Register to view this content.
Copy down to K20
While K13:K20 are still selected press Ctrl C (copy)
Select K23 and press Ctrl V (paste)
Note: while the formula finds the changes in rows 17 and 27 it did not find, nor did I by visual inspection, a change in row 24 (compared to row 14).
Let me know if you have any questions.
Edit: Thinking about this some more if the only possible change is with the component ID, as per title then change the formula to: =IF(E3=E13,"",K3+1) which is not an array entered formula, so just pressing Enter will suffice.
Last edited by JeteMc; 10-02-2016 at 06:24 PM. Reason: Added Edit and Formula
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks