Question description:
This user has given permission to use the problem statement for this
blog.
i need to compare numbers in 2 columns 400+ lines and have it report either 'in' or 'out' based on the outcome of the comparison of the two formulas.
one is a signed out column abd the other is the products that are returned
Solved by G. L. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/05/2018 - 04:15
Hi
User
29/05/2018 - 04:15
hello
Excelchat Expert
29/05/2018 - 04:15
Welcome to Got it Pro
Excelchat Expert
29/05/2018 - 04:15
Please tell me more about the requirement so that i can help better
User
29/05/2018 - 04:16
i need to compare two columns and have it return an in or out in a 3rd column
Excelchat Expert
29/05/2018 - 04:16
Can you paste the sample data
Excelchat Expert
29/05/2018 - 04:17
and tell the logic behind so that i can build the formula
User
29/05/2018 - 04:18
to track the monitros we have signed out to the ones returned and using the signed in column to tell me if its in or out
User
29/05/2018 - 04:18
A is my monitors ive signed out
User
29/05/2018 - 04:18
J is the ones that have been returned
Excelchat Expert
29/05/2018 - 04:18
what value do you want to return?
Excelchat Expert
29/05/2018 - 04:18
why 47 becomes 87?
User
29/05/2018 - 04:18
f is my final output
Excelchat Expert
29/05/2018 - 04:19
What would be the logic to generate formula for F?
User
29/05/2018 - 04:19
the j is just a sampl of the daily returns i have over 1000 outs and ins through the da
Excelchat Expert
29/05/2018 - 04:19
Tell me the logic so that i can build the formula
Excelchat Expert
29/05/2018 - 04:19
ok
User
29/05/2018 - 04:20
so i know if the one mpnitor had been returned
User
29/05/2018 - 04:20
it could be on like 3 or line 450
User
29/05/2018 - 04:20
needs to check the whole column and return the in or out
Excelchat Expert
29/05/2018 - 04:21
See column F
Excelchat Expert
29/05/2018 - 04:21
i have used vlookup to generate which are returned
Excelchat Expert
29/05/2018 - 04:21
matching values are populated in F
Excelchat Expert
29/05/2018 - 04:21
Do you see it?
User
29/05/2018 - 04:21
yes
Excelchat Expert
29/05/2018 - 04:22
Do you want me to in column F - Returned or not Returned?
Excelchat Expert
29/05/2018 - 04:22
See now
User
29/05/2018 - 04:22
its designed to turn white with conditional format once in is types into the cell
User
29/05/2018 - 04:23
that does work
Excelchat Expert
29/05/2018 - 04:23
Cool
Excelchat Expert
29/05/2018 - 04:23
See column F..hope this helps
User
29/05/2018 - 04:23
possible to not show the numbers and have it read as returned?
Excelchat Expert
29/05/2018 - 04:23
Yes i can do it..let me build
User
29/05/2018 - 04:24
awesome ive been fighing this for an hour, my ecal skills have disapeardover the years of not using it
Excelchat Expert
29/05/2018 - 04:24
See now
Excelchat Expert
29/05/2018 - 04:24
Hope this helps
User
29/05/2018 - 04:24
yea that perfect :D
Excelchat Expert
29/05/2018 - 04:25
Please do give good rating and reviews
Excelchat Expert
29/05/2018 - 04:25
It really helps
User
29/05/2018 - 04:25
oh i will you saves me tons of time
Excelchat Expert
29/05/2018 - 04:25
Thanks
Excelchat Expert
29/05/2018 - 04:26
You can provide your rating when you end the session
User
29/05/2018 - 04:26
ok thanks
Excelchat Expert
29/05/2018 - 04:26
welcome
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.