Hello,
with a macro it is possible to report the non-repeated values of column B6: B6000 of the sheet "in" in column I of the "grafici" sheet?
Thank you
max
Hello,
with a macro it is possible to report the non-repeated values of column B6: B6000 of the sheet "in" in column I of the "grafici" sheet?
Thank you
max
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi sinteek,
your macro works,
Is a change only possible values per month?
Example
01/01/19
02/01/19
02/01/19
08/01/19
08/01/19
20/01/19
20/01/19
only month Jan-19
01/02/19
02/02/19
02/02/19
08/02/19
08/02/19
20/02/19
20/02/19
only month feb-19
Just realised, your request was for non repeat values...So are you wanting the values that occur only once...
Is this what you envisage.
torachan.
I'm sorry I was wrong in formulating the question.
It must be present every month.
K, just add sort code if needed...
Please Login or Register to view this content.
Hi not work:
they must be present every month.Please Login or Register to view this content.
Why loop?
Please Login or Register to view this content.
Jondon error here:
With .Range("B6", Range("B" & Rows.Count).End(xlUp))
error 1004
error defined by the application or object
Missing red.pointPlease Login or Register to view this content.
Missed a period
Please Login or Register to view this content.
Jindon is not correct
they must be present every month.
Then
Please Login or Register to view this content.
Jindon is not correct
they must be present only the months
with the new macro it is only January
Like this...
Please Login or Register to view this content.
Your result shows the dates that don't exists in "In" sheet.
What are you really trying to do?
Sintek is almost correct.
the first 2 dates are inverted
Last edited by max_max; 09-07-2019 at 09:47 AM.
What file are you testing the code on...Perhaps supply this...
EDIT...Works with this one...
Last edited by sintek; 09-07-2019 at 09:50 AM.
Sintek the file
Put this
BeforePlease Login or Register to view this content.
Please Login or Register to view this content.
hello sintek now works.
I put your macro in other sheets and now it works for columns I / J / k / L / M sheet "grafici"
The formula (unique months) in the column N
for it to work you have to click in the columns of the columns I / J / k / L / M
Please Login or Register to view this content.
Sintek the new macro work well
The formula in column N of the "GRAFICI" sheet does not work
Not my formula...Is yours...Why not FixThe formula in column N of the "GRAFICI" sheet does not work
Leave this part out...
Please Login or Register to view this content.
Last edited by sintek; 09-07-2019 at 11:17 AM.
Yes my formula.
The formula
All months in the range $I$2:$M$20 unique,Please Login or Register to view this content.
Last edited by max_max; 09-07-2019 at 11:23 AM.
The formula is not working because the value in I2:M25 are not numbers. They are text.
You are trying to force an answer to something you did not start with.
You have yet to finish this thread.
HTH
Regards, Jeff
how to correct?
I don't like formulas...Does this work...The language is a barrier...
Please Login or Register to view this content.
Sintek the new macro is almost o.k.
It is not in ascending order.
Last edited by max_max; 09-07-2019 at 01:48 PM.
Come on max...by now you should know sort code for column...see previous post in this thread and amend for correct column...
I don't understand where Feb-19 is in the range I2-M25 must be Feb-20
Last edited by max_max; 09-07-2019 at 02:07 PM.
add red part
Please Login or Register to view this content.
O.k. sintek now works.
with macro recorderPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by max_max; 09-08-2019 at 09:04 AM.
An error
if in a sheet is present only row B6 error here:
error 13 type mismatchPlease Login or Register to view this content.
click on sheet "grafici" button "aggiorna" to update
Last edited by max_max; 09-08-2019 at 09:59 AM.
Please Login or Register to view this content.
Hi sintek,
the new macro works in part.
In the new attachment there is a new shhet "INFO" and the new macro shows the data of this sheet in the "grafici" sheet
Is correct this way:?
Please Login or Register to view this content.
NO...THE NEW MACRO WORKS FOR YOUR SCENARIO but now you change the scenario...the new macro works in part.
Come on now Max...Every post is a new scenario...
This is basics...Google is your friend...
EDIT...I see you are trying to learn...Yes that is correct...Well done...Please Login or Register to view this content.
I hope it's all right now.
Let's see tomorrow at the office.
Thank you
max
Good luckI hope it's all right now
Last edited by sintek; 09-08-2019 at 12:24 PM.
Hi sintek the macro work.
I have now posted the workbook for a data validation formula
Glad I could assist...Please mark this thread as solved...Tx for rep +Hi sintek the macro work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks