LinkBack URL
About LinkBacks
Hi All
I'm looking for help to solve the following:-
I wish to select the data in every 4th colum i.e. A, D, H, L etc
How can I do this ?
Would really appreciate any help.
Thanks
Hi All
I'm looking for help to solve the following:-
I wish to select the data in every 4th colum i.e. A, D, H, L etc
How can I do this ?
Would really appreciate any help.
Thanks
That series is NOT every 4th column.
Assuming you meant: A, E, I, M, Q, U, Y
This regular formula returns the sum of items in Row_1 for only those columns
Formula:
Please Login or Register to view this content.
Is that something you can work with?
Brillant, thanks I'll try that....
Hi Ron........Sorry but I just wish to extract the data in each 4th column which is an email address, that formula won't work for that will it ?
Well, now...you didn't say what you needed to do, so I just gave you a generic example.
To pull specific emails from Row_1, try this:
A2: the ordinal email to return....3
This regular formula returns the 3rd email...located in I1:
Is that something you can work with?
Please Login or Register to view this content.
Thanks Ron, much appreciate it.
That formula will extract the email address in every 4th column ?
Did you try it?
I put these values in my test sheet:
A1: 1
E1: 10
I1: 100
M1: 1000
When A2: 3
the formula returns: 100
Hi Ron
I just tried it, it didn't work, unless I'm doing it wrong.
I typed the formula into A3....
Basically all my data is going from A1 to BSQ, and every 4th one there is an email address which I'm trying to extract.
Open a blank workbook and build the example I posted. Remember that cell A2 is where you enter the item number you want to return.Originally Posted by Meger5
Better, yet...Open the attached example.
Unfortunately it still won't work.
I just need to extract the email address from D1, H1, L1, P1 etc all the way to BSQ
I'm really appreciative of your help.
Any other suggestions ?
i think you mean this filled down
=INDEX($1:$1,ROWS($A$1:A1)*4)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Time for you to post a sample workbook the exhibits what you want to do.
Hi Rob
Here is a sample worksheet, its just the emails I want to extract, nothing else......
testing.xlsx
Hi martindwilson
Your suggestion worked in that it selected the first email address only, however there are lots more.....
Copy that formula down as far as you need.Please Login or Register to view this content.
Here is a similar problem that can be adapted to do what you want. It uses named ranges. The logic isn't too difficult to follow.
http://www.excelforum.com/excel-gene...-one-list.html
See the entry by Pmcca37 message #12
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
well im surprised both what i posted an what Ron posted are the essentially the same thing ,both work fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks