Register
Log In
Unanswered
Home
March 10, 2016
Offline
hello,
I want to design a whole line duplicate entries
And bases have duplicate entries design only one column.
What do I need to set to succeed to design a whole line
According double value in one column which I'll define it
Thank you
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Don't know if I understand you well.
You have your input in column A and want the same values in columns B, C, D, E and so on? Then: (in B2): =A2 and copy that down and to the right.
But that sounds too simple, so I'm afraid you mean something else? Can you show what you want in an Excel file?
March 10, 2016
Offline
Thanks
I have attached the file
And painted the line that the code manually repeated in column A
I want to set conditional formatting rule
It will examine only whether the figure in column A is repeated
If so automated that will shape the line.
Dashboards
June 25, 2016
Offline
Hi lea
See the attachment.
One uses a helper column and the other uses formulas in the conditional formatting itself.
Both will detect duplicates/triplicates etc.
Hope this helps.
Sunny
Most Users Ever Online: 57
Currently Online: Mark Lund, Rudi, Max Neumann
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
