Sir .. i have to enter 100 values from a1 to a100
But A3,A16,A29,A42......(Increment of 13 in successoin) cells cant repeat values....
pls help
Sir .. i have to enter 100 values from a1 to a100
But A3,A16,A29,A42......(Increment of 13 in successoin) cells cant repeat values....
pls help
Please provide an example of what you want. Your explanation is a bit vague. Mock up a spreadsheet showing a representative sample of what you need.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Sir ..sorry for the misleading thread...here by am sending an attachment for my requirement
If I understand the attachment correctly then the following may help:
1) The SL column (G) may be populated by typing the first SL number (2) in the cell at the top of the column then use the following formula:Formula:Please Login or Register to view this content.
2) The Name column is populated using:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
A bit confusing.... Mybe this in F6:
=INDEX(C:C,1+4*(ROWS($1:1)-1))&""
and this in E6:
=IF(F6="","",INDEX(A:A,1+4*(ROWS($1:1)-1)))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks