Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
I want to have the program select every 70th cell and put a symbol in it.
The population is 685 cells. Can excel do this with out me having to move and manually select? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
for i=1 to 685 step 70
cells(i,"a")=?? next i -- Don Guillett Microsoft MVP Excel SalesAid Software "cbpfaff" wrote in message ... I want to have the program select every 70th cell and put a symbol in it. The population is 685 cells. Can excel do this with out me having to move and manually select? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
What is currently in each 70th cell?
Which column? If using Excel 2007, which row? Would any data be replaced or would the symbol be appended to existing data? Would the appending be ahead of existing data or following? What type of symbol? A macro could do it easily but to tailor it to your needs, please provide some more detail. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 16:25:01 -0800, cbpfaff wrote: I want to have the program select every 70th cell and put a symbol in it. The population is 685 cells. Can excel do this with out me having to move and manually select? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
I am not totally following your instructions. What is 'i' and what is 'a'?
Or better yet, can you email me an example? "Don Guillett" wrote: for i=1 to 685 step 70 cells(i,"a")=?? next i -- Don Guillett Microsoft MVP Excel SalesAid Software "cbpfaff" wrote in message ... I want to have the program select every 70th cell and put a symbol in it. The population is 685 cells. Can excel do this with out me having to move and manually select? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
empty cells for the 70th selections. column G. What I have is a selection
of transactions that I want to select every 70th one. I have a population of 685 transactions. The cell with the transaction will not be replaced. "Gord Dibben" wrote: What is currently in each 70th cell? Which column? If using Excel 2007, which row? Would any data be replaced or would the symbol be appended to existing data? Would the appending be ahead of existing data or following? What type of symbol? A macro could do it easily but to tailor it to your needs, please provide some more detail. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 16:25:01 -0800, cbpfaff wrote: I want to have the program select every 70th cell and put a symbol in it. The population is 685 cells. Can excel do this with out me having to move and manually select? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
Hi cb,
Put 1 in G70 Then Highlight G1 to G70 Grab the fill handle and drag down to the end of your data, hold down Ctrl before you let go of the fill handle Then select all of your data and go to DataFilterAutofilter On the G dropdown select 1 HTH Martin "cbpfaff" wrote in message ... empty cells for the 70th selections. column G. What I have is a selection of transactions that I want to select every 70th one. I have a population of 685 transactions. The cell with the transaction will not be replaced. "Gord Dibben" wrote: What is currently in each 70th cell? Which column? If using Excel 2007, which row? Would any data be replaced or would the symbol be appended to existing data? Would the appending be ahead of existing data or following? What type of symbol? A macro could do it easily but to tailor it to your needs, please provide some more detail. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 16:25:01 -0800, cbpfaff wrote: I want to have the program select every 70th cell and put a symbol in it. The population is 685 cells. Can excel do this with out me having to move and manually select? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
Every 70th cell is blank in a list of 685 transactions?
Select column G and F5SpecialBlanksOK With blanks still selected...........InsertSymbol Find one you like and hit "insert" at lower right. Close then CTRL + ENTER to copy symbol down in blank cells. Gord On Fri, 25 Jan 2008 16:50:02 -0800, cbpfaff wrote: empty cells for the 70th selections. column G. What I have is a selection of transactions that I want to select every 70th one. I have a population of 685 transactions. The cell with the transaction will not be replaced. "Gord Dibben" wrote: What is currently in each 70th cell? Which column? If using Excel 2007, which row? Would any data be replaced or would the symbol be appended to existing data? Would the appending be ahead of existing data or following? What type of symbol? A macro could do it easily but to tailor it to your needs, please provide some more detail. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 16:25:01 -0800, cbpfaff wrote: I want to have the program select every 70th cell and put a symbol in it. The population is 685 cells. Can excel do this with out me having to move and manually select? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
This sounds like a similar problem, and I think a macro is the solution, but
I can't figure out how to write it. I use excel for a large modeling spreadsheet, where the columns represent displacement and the rows are time, but it takes several rows to track all of the events in time. When done, I can select any row and plot those values and get a visualization of distribution over distance at a fixed time. But what I really want is to visualize at a fixed distance (a selected column), how distribution changes with time. To do this, I have to select every 4th or 5th cell in that column (depending on the particular model version) and plot those values. The ideal solution would be a macro where the desired column (distance) is requested as an input and then the plot is displayed. I have never worked with macros, so perhaps some general help and a reference to a tutorial (if one exists) would be the best bet. TIA. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select every 70th cell and put a symbol in it?
You've got responses at your other posting.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the @ symbol in a cell | Excel Discussion (Misc queries) | |||
Repeat symbol in a cell?? | Excel Worksheet Functions | |||
How can I remove the % symbol from a cell. Thanks | Excel Discussion (Misc queries) | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |