tick mark or what ?

Case 1 - it works the way i want it - case 2 the whole arry is written. 
why? 'where is my thinking going wrong'?
ist's just the blank (Write-Host $i"." $...||Write-Host $i". "$...)
1.
[array]$SaveLast10Decembers=@(Get-ChildItem | where-object {$_.name 
-match "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})
Write-Host $i"." $SaveLast10Decembers[$SaveLast10Decembers.count-1].name 
"wird verschoben" | Out-File $LogFileName -append

--> 1. YMAT1_20091231_SAP-JOB.txt wird verschoben
2.
[array]$SaveLast10Decembers=@(Get-ChildItem | where-object {$_.name 
-match "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})
Write-Host $i". "$SaveLast10Decembers[$SaveLast10Decembers.count-1].name 
"wird verschoben" | Out-File $LogFileName - append
--> 1. YMAT1_20091201_SAP-JOB.txt YMAT1_20091202_SAP-JOB.txt 
YMAT1_20091203_SAP-JOB.txt YMAT1_20091204_SAP-JOB.txt 
YMAT1_20091205_SAP-JOB.txt YMAT1_20091206_SAP-JOB.txt 
YMAT1_20091207_SAP-JOB.txt YMAT1_20091208_SAP-JOB.txt 
YMAT1_20091209_SAP-JOB.txt YMAT1_20091210_SAP-JOB.txt 
YMAT1_20091211_SAP-JOB.txt YMAT1_20091212_SAP-JOB.txt 
YMAT1_20091213_SAP-JOB.txt YMAT1_20091214_SAP-JOB.txt 
YMAT1_20091215_SAP-JOB.txt YMAT1_20091216_SAP-JOB.txt 
YMAT1_20091217_SAP-JOB.txt YMAT1_20091218_SAP-JOB.txt 
YMAT1_20091219_SAP-JOB.txt YMAT1_20091220_SAP-JOB.txt 
YMAT1_20091221_SAP-JOB.txt YMAT1_20091222_SAP-JOB.txt 
YMAT1_20091223_SAP-JOB.txt YMAT1_20091224_SAP-JOB.txt 
YMAT1_20091225_SAP-JOB.txt YMAT1_20091226_SAP-JOB.txt 
YMAT1_20091227_SAP-JOB.txt YMAT1_20091228_SAP-JOB.txt 
YMAT1_20091229_SAP-JOB.txt YMAT1_20091230_SAP-JOB.txt 
YMAT1_20091231_SAP-JOB.txt[YMAT1_20091201_SAP-JOB.txt 
YMAT1_20091202_SAP-JOB.txt YMAT1_20091203_SAP-JOB.txt 
YMAT1_20091204_SAP-JOB.txt YMAT1_20091205_SAP-JOB.txt 
YMAT1_20091206_SAP-JOB.txt YMAT1_20091207_SAP-JOB.txt 
YMAT1_20091208_SAP-JOB.txt YMAT1_20091209_SAP-JOB.txt 
YMAT1_20091210_SAP-JOB.txt YMAT1_20091211_SAP-JOB.txt 
YMAT1_20091212_SAP-JOB.txt YMAT1_20091213_SAP-JOB.txt 
YMAT1_20091214_SAP-JOB.txt YMAT1_20091215_SAP-JOB.txt 
YMAT1_20091216_SAP-JOB.txt YMAT1_20091217_SAP-JOB.txt 
YMAT1_20091218_SAP-JOB.txt YMAT1_20091219_SAP-JOB.txt 
YMAT1_20091220_SAP-JOB.txt YMAT1_20091221_SAP-JOB.txt 
YMAT1_20091222_SAP-JOB.txt YMAT1_20091223_SAP-JOB.txt 
YMAT1_20091224_SAP-JOB.txt YMAT1_20091225_SAP-JOB.txt 
YMAT1_20091226_SAP-JOB.txt YMAT1_20091227_SAP-JOB.txt 
YMAT1_20091228_SAP-JOB.txt YMAT1_20091229_SAP-JOB.txt 
YMAT1_20091230_SAP-JOB.txt YMAT1_20091231_SAP-JOB.txt.count-1].name
0
Thorsten
3/25/2010 7:58:14 AM
windows.powershell 690 articles. 0 followers. Follow

2 Replies
1345 Views

Similar Articles

[PageSpeed] 7

Thorsten A. Oeltjen wrote:
> Case 1 - it works the way i want it - case 2 the whole arry is written. 
> why? 'where is my thinking going wrong'?
> ist's just the blank (Write-Host $i"." $...||Write-Host $i". "$...)
> 1.
> [array]$SaveLast10Decembers=@(Get-ChildItem | where-object {$_.name 
> -match "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})
> Write-Host $i"." $SaveLast10Decembers[$SaveLast10Decembers.count-1].name 
> "wird verschoben" | Out-File $LogFileName -append
> 
> --> 1. YMAT1_20091231_SAP-JOB.txt wird verschoben
> 2.
> [array]$SaveLast10Decembers=@(Get-ChildItem | where-object {$_.name 
> -match "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})
> Write-Host $i". "$SaveLast10Decembers[$SaveLast10Decembers.count-1].name 
> "wird verschoben" | Out-File $LogFileName - append
> --> 1. YMAT1_20091201_SAP-JOB.txt YMAT1_20091202_SAP-JOB.txt 
> YMAT1_20091203_SAP-JOB.txt YMAT1_20091204_SAP-JOB.txt 
> YMAT1_20091205_SAP-JOB.txt YMAT1_20091206_SAP-JOB.txt 
> YMAT1_20091207_SAP-JOB.txt YMAT1_20091208_SAP-JOB.txt 
> YMAT1_20091209_SAP-JOB.txt YMAT1_20091210_SAP-JOB.txt 
> YMAT1_20091211_SAP-JOB.txt YMAT1_20091212_SAP-JOB.txt 
> YMAT1_20091213_SAP-JOB.txt YMAT1_20091214_SAP-JOB.txt 
> YMAT1_20091215_SAP-JOB.txt YMAT1_20091216_SAP-JOB.txt 
> YMAT1_20091217_SAP-JOB.txt YMAT1_20091218_SAP-JOB.txt 
> YMAT1_20091219_SAP-JOB.txt YMAT1_20091220_SAP-JOB.txt 
> YMAT1_20091221_SAP-JOB.txt YMAT1_20091222_SAP-JOB.txt 
> YMAT1_20091223_SAP-JOB.txt YMAT1_20091224_SAP-JOB.txt 
> YMAT1_20091225_SAP-JOB.txt YMAT1_20091226_SAP-JOB.txt 
> YMAT1_20091227_SAP-JOB.txt YMAT1_20091228_SAP-JOB.txt 
> YMAT1_20091229_SAP-JOB.txt YMAT1_20091230_SAP-JOB.txt 
> YMAT1_20091231_SAP-JOB.txt[YMAT1_20091201_SAP-JOB.txt 
> YMAT1_20091202_SAP-JOB.txt YMAT1_20091203_SAP-JOB.txt 
> YMAT1_20091204_SAP-JOB.txt YMAT1_20091205_SAP-JOB.txt 
> YMAT1_20091206_SAP-JOB.txt YMAT1_20091207_SAP-JOB.txt 
> YMAT1_20091208_SAP-JOB.txt YMAT1_20091209_SAP-JOB.txt 
> YMAT1_20091210_SAP-JOB.txt YMAT1_20091211_SAP-JOB.txt 
> YMAT1_20091212_SAP-JOB.txt YMAT1_20091213_SAP-JOB.txt 
> YMAT1_20091214_SAP-JOB.txt YMAT1_20091215_SAP-JOB.txt 
> YMAT1_20091216_SAP-JOB.txt YMAT1_20091217_SAP-JOB.txt 
> YMAT1_20091218_SAP-JOB.txt YMAT1_20091219_SAP-JOB.txt 
> YMAT1_20091220_SAP-JOB.txt YMAT1_20091221_SAP-JOB.txt 
> YMAT1_20091222_SAP-JOB.txt YMAT1_20091223_SAP-JOB.txt 
> YMAT1_20091224_SAP-JOB.txt YMAT1_20091225_SAP-JOB.txt 
> YMAT1_20091226_SAP-JOB.txt YMAT1_20091227_SAP-JOB.txt 
> YMAT1_20091228_SAP-JOB.txt YMAT1_20091229_SAP-JOB.txt 
> YMAT1_20091230_SAP-JOB.txt YMAT1_20091231_SAP-JOB.txt.count-1].name

It's having trouble reading your expression, see the last line here:

 > YMAT1_20091230_SAP-JOB.txt YMAT1_20091231_SAP-JOB.txt.count-1].name

It's taken the part which is supposed to select an element in the array 
and added it to your output.

The simplest way to fix that is to execute it in a Sub-Expression:

$SaveLast10Decembers = @(Get-ChildItem | where-object {$_.name -match 
"$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})

Write-Host $($i". 
"$($SaveLast10Decembers[$SaveLast10Decembers.count-1].name) "wird 
verschoben") | Out-File $LogFileName - append

Perhaps this might be easier:

Get-ChildItem | `
   where-object {$_.name -match 
"$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"} | `
   Select-Object -Last 1 | `
   "$i $($_.Name) wird verschoben" | `
   Out-File $LogFileName -Append

$i is uninitialised in the snippet, I assume that's done elsewhere.

You can also do this:

$SaveLast10Decembers = @(Get-ChildItem | where-object {$_.name -match 
"$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})

Write-Host $($i". "$($SaveLast10Decembers[-1].name) "wird verschoben") | 
Out-File $LogFileName - append

Using -1 on it's own as an array index will give you the last element 
without needing to get count first.

Chris
0
Chris
3/25/2010 9:09:05 AM
@chris
10E3thx - very helpfull. i found out, that it was a missing blank after "
but your ideas made my eyes open ... sry, my english



Am 25.03.2010 10:09, schrieb Chris Dent:
> Thorsten A. Oeltjen wrote:
>> Case 1 - it works the way i want it - case 2 the whole arry is
>> written. why? 'where is my thinking going wrong'?
>> ist's just the blank (Write-Host $i"." $...||Write-Host $i". "$...)
>> 1.
>> [array]$SaveLast10Decembers=@(Get-ChildItem | where-object {$_.name
>> -match "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})
>> Write-Host $i"."
>> $SaveLast10Decembers[$SaveLast10Decembers.count-1].name "wird
>> verschoben" | Out-File $LogFileName -append
>>
>> --> 1. YMAT1_20091231_SAP-JOB.txt wird verschoben
>> 2.
>> [array]$SaveLast10Decembers=@(Get-ChildItem | where-object {$_.name
>> -match "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})
>> Write-Host $i".
>> "$SaveLast10Decembers[$SaveLast10Decembers.count-1].name "wird
>> verschoben" | Out-File $LogFileName - append
>> --> 1. YMAT1_20091201_SAP-JOB.txt YMAT1_20091202_SAP-JOB.txt
>> YMAT1_20091203_SAP-JOB.txt YMAT1_20091204_SAP-JOB.txt
>> YMAT1_20091205_SAP-JOB.txt YMAT1_20091206_SAP-JOB.txt
>> YMAT1_20091207_SAP-JOB.txt YMAT1_20091208_SAP-JOB.txt
>> YMAT1_20091209_SAP-JOB.txt YMAT1_20091210_SAP-JOB.txt
>> YMAT1_20091211_SAP-JOB.txt YMAT1_20091212_SAP-JOB.txt
>> YMAT1_20091213_SAP-JOB.txt YMAT1_20091214_SAP-JOB.txt
>> YMAT1_20091215_SAP-JOB.txt YMAT1_20091216_SAP-JOB.txt
>> YMAT1_20091217_SAP-JOB.txt YMAT1_20091218_SAP-JOB.txt
>> YMAT1_20091219_SAP-JOB.txt YMAT1_20091220_SAP-JOB.txt
>> YMAT1_20091221_SAP-JOB.txt YMAT1_20091222_SAP-JOB.txt
>> YMAT1_20091223_SAP-JOB.txt YMAT1_20091224_SAP-JOB.txt
>> YMAT1_20091225_SAP-JOB.txt YMAT1_20091226_SAP-JOB.txt
>> YMAT1_20091227_SAP-JOB.txt YMAT1_20091228_SAP-JOB.txt
>> YMAT1_20091229_SAP-JOB.txt YMAT1_20091230_SAP-JOB.txt
>> YMAT1_20091231_SAP-JOB.txt[YMAT1_20091201_SAP-JOB.txt
>> YMAT1_20091202_SAP-JOB.txt YMAT1_20091203_SAP-JOB.txt
>> YMAT1_20091204_SAP-JOB.txt YMAT1_20091205_SAP-JOB.txt
>> YMAT1_20091206_SAP-JOB.txt YMAT1_20091207_SAP-JOB.txt
>> YMAT1_20091208_SAP-JOB.txt YMAT1_20091209_SAP-JOB.txt
>> YMAT1_20091210_SAP-JOB.txt YMAT1_20091211_SAP-JOB.txt
>> YMAT1_20091212_SAP-JOB.txt YMAT1_20091213_SAP-JOB.txt
>> YMAT1_20091214_SAP-JOB.txt YMAT1_20091215_SAP-JOB.txt
>> YMAT1_20091216_SAP-JOB.txt YMAT1_20091217_SAP-JOB.txt
>> YMAT1_20091218_SAP-JOB.txt YMAT1_20091219_SAP-JOB.txt
>> YMAT1_20091220_SAP-JOB.txt YMAT1_20091221_SAP-JOB.txt
>> YMAT1_20091222_SAP-JOB.txt YMAT1_20091223_SAP-JOB.txt
>> YMAT1_20091224_SAP-JOB.txt YMAT1_20091225_SAP-JOB.txt
>> YMAT1_20091226_SAP-JOB.txt YMAT1_20091227_SAP-JOB.txt
>> YMAT1_20091228_SAP-JOB.txt YMAT1_20091229_SAP-JOB.txt
>> YMAT1_20091230_SAP-JOB.txt YMAT1_20091231_SAP-JOB.txt.count-1].name
>
> It's having trouble reading your expression, see the last line here:
>
>  > YMAT1_20091230_SAP-JOB.txt YMAT1_20091231_SAP-JOB.txt.count-1].name
>
> It's taken the part which is supposed to select an element in the array
> and added it to your output.
>
> The simplest way to fix that is to execute it in a Sub-Expression:
>
> $SaveLast10Decembers = @(Get-ChildItem | where-object {$_.name -match
> "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})
>
> Write-Host $($i".
> "$($SaveLast10Decembers[$SaveLast10Decembers.count-1].name) "wird
> verschoben") | Out-File $LogFileName - append
>
> Perhaps this might be easier:
>
> Get-ChildItem | `
> where-object {$_.name -match
> "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"} | `
> Select-Object -Last 1 | `
> "$i $($_.Name) wird verschoben" | `
> Out-File $LogFileName -Append
>
> $i is uninitialised in the snippet, I assume that's done elsewhere.
>
> You can also do this:
>
> $SaveLast10Decembers = @(Get-ChildItem | where-object {$_.name -match
> "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"})
>
> Write-Host $($i". "$($SaveLast10Decembers[-1].name) "wird verschoben") |
> Out-File $LogFileName - append
>
> Using -1 on it's own as an array index will give you the last element
> without needing to get count first.
>
> Chris

0
Thorsten
3/25/2010 1:54:53 PM
Reply:

Similar Artilces:

tick
hi sorry if this has been covered before.. How can insert/type a 'tick' mark into a cell? Sometimes I like want to insert 2 (or more) ticks into a cell so what I really need is to insert the mark using the keyboard. I have tried insert/picture/shapes, insert/symbol but can't find it. The closest I have come is to use insert/picture but this is obviously hopeless. Anyone help? MTIA Elwyn Hi Elwyn! First change the font using Format > Cells > Font and select Wingdings from the drop down. With the Numlock on: Hold down Alt and type 0252. On releasing Alt it prod...

ticking box
how i add ticking box in worksheet (cell) Insert a CheckBox from the Forms toolbar (View>Toolbars>Forms). To link that to acell right click on the checkbox>FormatControl>In 'Control' tab > Cell link type the cell reference say A1.. -- Jacob (MVP - Excel) "deeps-k" wrote: > how i add ticking box in worksheet (cell) ...

How to mark key dates on chart?
I have a chart that shows change in blood pressure over time. I would like to mark on the graph certain key dates (x values), for example where diet changes. Can I do that with excel charts? Also, I would like to highlight a band of y values (e.g. blood pressure between 120-140). Can I do that? Thanks for any help, Huck "Huck Rorick" <huckrorick@groundwork.org> wrote in message news:e8T$ZHV9HHA.2752@TK2MSFTNGP06.phx.gbl... >I have a chart that shows change in blood pressure over time. I would like >to mark on the graph certain key dates (x values), fo...

Change everybody's preview pane setting to mark as read
I keep getting read receipts which say "messages was deleted without being read" because some people in my organisation use the preview pane. The procedure to turn in the option which will "mark items as read when viewed using preview pane" will solve all this. My question is : Is there a way to turn this "mark as read..." setting on globally for every Outlook user in my organisation? (I've seen a command line switch the will take away the preview pane altogether but I don't want to do that, maybe something similar exists that will solve my pro...

Tick Boxes
if you have 10 tick boxes running vertically in a worksheet, can you count how many have been ticked at the bottom??????:p ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ Hi Alan, When you say tick boxes, do you mean either option buttons or chec boxes? Dave M ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Let me teach you the following trick F...

tick boxes
How do I make a field into to a tick box? Ta Jon data-> validation --- Message posted from http://www.ExcelForum.com/ You can add check boxes to the worksheet from the Forms toolbar, or from the Control toolbox. To see the list of toolbars, choose View>Toolbars. JON wrote: > How do I make a field into to a tick box? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html sorry what i wrote was wrong :mad: --- Message posted from http://www.ExcelForum.com/ ...

How do I show messages marked for deletion on Microsoft Outlook?
Microsoft Outlook 2003 When I delete messages in my Inbox (or any other folder) they are currently hidden. How do I change that so that the messages I click for deletion show up with a line through them? Conversely once I've done that if I want to change back to having messages marked for deletion hidden, how do I do that? THRP <THRP@discussions.microsoft.com> wrote: > Microsoft Outlook 2003 > When I delete messages in my Inbox (or any other folder) they are > currently hidden. How do I change that so that the messages I click > for deletion show up with a line thr...

TICK SYMBOL
i want to be able to use a tick symbol on a regular basis. how can i add it to the task bar for easy access. WORD 2007 Hi Annie, I have just put up a file for you at:- http://www.pierrefondes.com/ Item number 100. This shows you how to do what you want in WORD 2007. If my comments have helped please hit Yes. Thanks. "annie" wrote: > i want to be able to use a tick symbol on a regular basis. how can i add it > to the task bar for easy access. ...

Custom tic marks for slider
I want to set custom tic marks for a slider control. For example, say I set the range to be 1 to 100. I might want to set the tic marks at positions 2, 5, 12, 40, and 76. There is no pattern or frequency to this. Any ideas about how to do this? Thanks You will have to draw it yourself. Basically all you have to do is inherit from a CSliderCtrl, catch the NM_CUSTOMDRAW notification (OnCustomDraw). In there you have to check for NMCUSTOMDRAW structs dwDrawStage to be CDDS_ITEMREPAINT and the dwItemSpec to be TBCD_TICS. That's when its asking you to draw the ticks. This is a ...

Mark as unreconciled with Money 2007
I've downloaded and accepted a lot of transactions YTD that have all been auto-reconciled. I didn't realize that was happening until I wanted to balance against my paper statement. Is there a way to select multiple transactions (all) and mark as unreconciled? In microsoft.public.money, bran100 wrote: >I've downloaded and accepted a lot of transactions YTD that have all >been auto-reconciled. I didn't realize that was happening until I >wanted to balance against my paper statement. > >Is there a way to select multiple transactions (all) and mark as >unrecon...

Hash marks in a chart
I have a chart where I am charting Left Center and Right weights of a strip of material. My chart is fine for showing the average of these 3 measurements and I have a second chart showing the ranges. But I also need it to show hash marks for each of the L, C, R measurements. So, for example. left =260 center = 257 right = 263 The average is shown using the standard charting but the individual numbers (260, 257, 263) need to be shown also Now the left , center, and right on the chart will need to be represented like this: Left = \ Center = - Right = / Any Idea how I might accomplish this? ...

Testing Prepended Question Mark bug with IE9 Beta 1 installed (WLMail)
?Test... Headers from Message Source (Ctrl+F3 in Drafts): MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8117.416 -- Peter.R (Windows Live Mail 2009 14.0.8117.0416 on Windows 7 Home Premium) "There are more things in Heaven and earth, Horatio, than are dreamt of in your philosophy." - Shakespeare ´╗┐Test of Unicode (UTF-8) workaround... Headers from Message...

Integration Manager
I am working on an Integration where the source is a table in Microsoft SQL. I am using IM 10. and Great Plains 10. I have the flexibility of changing the structure of the table in SQL. I have the following questions: 1. I would like to time stamp the record that has been successfuly imported into Great Plains using integration Manager. Is there any way to do this? Do I need to do this as the integration is running or after it has run? 2. If errors arise for a specific record during the integration, can I mark the record so that next time I upload the integration, only those reco...

tick mark labels
How can I increase the quanity of tick mark labels along the x-axis in a graph? I.E. Excel only puts my Date/Time tick mark labels at the beginning of each day. I'd like to show tick mark labels every 6 hours. You can change the scale of the X axis to be every 6 hours (.25 day) IF you are using an XY Scatter chart. If it's a LINE chart, you can't do it. "Debrane" <Debrane@discussions.microsoft.com> wrote in message news:C2FB7D25-01C9-407D-9759-F31AC4BA037A@microsoft.com... > How can I increase the quanity of tick mark labels along the x-axis in a > g...

tick mark or what ?
Case 1 - it works the way i want it - case 2 the whole arry is written. why? 'where is my thinking going wrong'? ist's just the blank (Write-Host $i"." $...||Write-Host $i". "$...) 1. [array]$SaveLast10Decembers=@(Get-ChildItem | where-object {$_.name -match "$FileYearDecember\d{2}_\w{3}-\w{3}\.\w{3}$"}) Write-Host $i"." $SaveLast10Decembers[$SaveLast10Decembers.count-1].name "wird verschoben" | Out-File $LogFileName -append --> 1. YMAT1_20091231_SAP-JOB.txt wird verschoben 2. [array]$SaveLast10Decembers=@(Get-Chil...

Macro/Word converting double-quote marks into angle quotation marks
Hi all, I've scripted a vba macro that opens html pages in txt format and adds the following line after <BODY> (through a search and replace): <link rel="stylesheet" type="text/css" href="Output.css" /> The problem I'm having is that Word or the macro (don't really know) is converting the double-quote marks into angled quotation marks (ASCII 147 and 148), which makes the line above unreadable by the browser. I've tried using Chr(34): "<BODY><link rel=" & Chr(34) & "stylesheet" & ...

How do you unmark a transaction that is currently marked as "E"
M2003 has some real difficulty reconciling downloaded transactions sometimes because it refuses to associate a newly downloaded transaction that corresponds to something that was downloaded earlier (and hence marked as E). This could be for various reasons e.g., glitches in the bank's download where the transaction is sent repeatedly, When I duplicate a previous transaction (to re-use it's splits) and change it's date, that duplicated transaction is also marked with E. When this is downloaded from the bank, M2003 refuses to allow me to associate the downloaded transaction to this...

"X" marks the spot
I am working on a call center checklist and I am trying to get c10 t display "X" when b10 is clicked on, c11 to display "X" when b11 i clicked on, and c12 to display "X" when clicked on. This process wil continue with d10/e10, d11/e11, etc. The sheet sample is included for clarification. Thanks for any help in advance, and a good day to all. Vato Attachment filename: sample.xls Download attachment: http://www.excelforum.com/attachment.php?postid=61512 -- Message posted from http://www.ExcelForum.com Hi try the following worksh...

tick formula #3
Thank you for your kind help! I'm very nearly there - you were right, it's because I have a Frenc version of Excel, and the error in the column E says "NOM" which mean "NAME" Otherwise, it works perfectly. Could you have a look and tell me what have to do to get it right? Thanks agai +------------------------------------------------------------------- |Filename: tick formula.zip |Download: http://www.excelforum.com/attachment.php?postid=2735 +------------------------------------------------------------------- -- j...

Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in? TIA. Rich On Tue, 26 Apr 2005 04:44:35 -1000, rmc <rmc@nospam.com> wrote: > Is there a way to do this, or an add-in? What version of Outlook are you using? -- -Ben- Ben M. Schorr, MVP Hi Ben: 2003 SP1 Rich "Ben M. Schorr - MVP" <bens@bogusaddress.mvp> wrote in message news:op.spuxh8sf6r4cx1@bms-tablet2.scgab.com... > On Tue, 26 Apr 2005 04:44:35 -1000, rmc <rmc@nospam.com> wrote: > > > Is there a way to do this, or an add-in? > > What version of Outlook are you using? > > > -- >...

Tick or Toggle
I need to put a manual toggle (or tick box, check box, radio button, whatever) in each cell of a column so that if the toggle is on/ticked (value 1), a formula extracts the value from an adjacent cell, performs a mathematical function on it and enters the result in a third cell. i.e : Cell A1 contains the toggle (or tick box/check box/radio button) Cell B1 contains a numerical value Cell C1 contains the formula. If Cell A1 toggle is on/ticked, the formula in Cell C1 extracts the value from Cell B1, performs a mathematical function on it and enters the result in Cell C1, otherwise (if t...

Tick Marks on Graphs
I am trying to alter the numbering and location of the ticks on the X-axis, because I need to be able to have each tick mark directly on the number. As it, each point is graphed in between 2 marks. I hope this makes sense, because I need to change the formatting of this in order to complete this graph. Help! Hi Datura, You don't say what type of chart you are using, so I will assume line. Either change the chart type to xy-scatter, which uses true values on the xaxis. Or if a line type select the xaxis and press CTRL+1 to display the format dialog. On the scale tab uncheck the Y axis ...

Tick marks
Hi, I am looking to use a tick mark and an X for incorrect in a cell. I can't find either in Excel. Does anyone know how I might go about getting them? I'm basically writing a simple maths work sheet. With something such as 2+3= Each of the characters is in a separate cell and if the student gets the correct answer a tick symbol comes up in the next cell. I also want their score to be at the top of the sheet as they go. Any help would be greatly appreciated. Regards, Shane -- ofey ------------------------------------------------------------------------ ofey's Profile...

Tick Marks On Axis: How, Please ?
Hello, Using Excel 2007 How do I puill up something for a chart that allows me to play with the options for Tick-Marks on one of the axis ? Thanks, B. Select the axis, use ctrl/1 or right-click & select Format Axis. On the Axis options section, in the middle, you'll see Major tick mark type, etc -- choose inside, outside, none, or cross. HTH Bob Umlas Excel MVP "Robert11" wrote: > Hello, > > Using Excel 2007 > > How do I puill up something for a chart that allows me to play with the > options for Tick-Marks on one of the axis ? > > Tha...

How do you put a tick in excel?
Can anyone tell me how to put a tick in excel and word? Hi you have received several anwers to your old post -- Regards Frank Kabel Frankfurt, Germany "Lorraine" <Lorraine@discussions.microsoft.com> schrieb im Newsbeitrag news:2B012C15-9B94-42A3-8641-1E5C06EE9A92@microsoft.com... > Can anyone tell me how to put a tick in excel and word? Something tells me it just might not be the same poster <g> Try this link to the "old" post: http://tinyurl.com/5rks2 -- Rgds Max xl 97 --- Please respond in thread xdemechanik <at>yahoo<dot>com ---- "F...