lose

Hello, I discovered something today which scared me. Yesterday I had a PersonalXLSB workbook with a number of macros stored. Today, I saw a Personal(AutoRecovered)XLSB workbook with the same macros but named with the Personal(AutoRecovered).xlsb!macro name. I do not know how this happened...

I want to concatenate 2 $ amounts but I lose the $ and the , in between the numbers. For example: A1 = $100,000 B1 = $200,000 C1 = concatenate (a1," & ",B1) The result I get is 100000 & 200000 So I lose the $ and the commas. Any suggestions? thanks

If you can do this , you are a genius!! formula for a roulette betting system in excel based on the Fibonacci sequence. The sequence goes like this: 1 – 1 – 2 – 3 – 5 – 8 – 13 – 21 – 34 – 55 – 89 – 144 – 233 – 377 – 610 – 987 – … You might have noticed (or you already knew) that each of the...

How can I retain the hyperlinks when I save my excel file to a new name

Well hello everyone... I have posted this before, but since i got no replies or help, i thought i would repost it and ask it a bit differently or something. So i have an sheet where i want to keep track of my coinflips.. But to make life easy i want to just write down simple things and then...

Hello everyone, Today I want to make a sheet that contains all the information about coinflips. I am playing a game where coinflipping is a thing and i'm quite addicted to it. Now there is kind of a tactic to get good guesses at it and a big help would be tracking down information. However I...

What's the correct way for a UserForm) combo box to Lose the focus? I anticipate calling this from the cbo_Change event. I did try to setFocus to a text box (left = -50) but you still see a flashing cursor , so made the left -999 and locked = True. That did it but seems a hack and there must be...

HI Is it possible to use VLOOKUP to "fetch" the greater than or less than symbol in an IF function. Effectively =If(A1>B1,"WIN","LOSE") would be something like =If(A1"VLOOKUP(C3,D6:E11,2,FALSE)",B1,"WIN","LOSE") Thanks in advance

I am using the below line of code to repeatedly copy a sheet over another sheet called "FINALORDER". But the formatting is not getting copied as I lose the column widths. What additional code do I need to accomplish this? Thanks Sheets(Result).UsedRange.Copy Sheets("FINALORDER").Cells(1, 1)

I have tried this every way I could.....I can't get to work but they work seperately. =countif('Data Collection'!$d$7:$D:$2000,"GA") =offset('data Collection'!$D$6,1,,2000) D6 is the header. the data begins D7, but when I insert new row, I lose my data for my chart. The formula moves with it...

Hi folks, looking for a little help again. I am trying to do a small ‘drawdown’ sheet for my trading account. I use a 3 to 1 risk ratio. I am willing to risk ‘1’ (2% of my account) to make ’3’ (6% gain). Each time I lose a trade, I lose 2% of my account, so 4 consecutive losing trade, means I...

Hello Dears, As in image above : i am trying to make a formula for column J and K: - As in column "J" i need the Pips In Lose to be calculated in case i type "L" in column "I" - As in column "K" i need the Pips in Profit to be calculated in case i type "P" in column "I" - In column "I" when i...

Hi, i have a pivot table with: 1 field in Rows + 4 fields in values when my data is cleared and pivot refreshed, i lose 2 of the 4 value fields. How can i make sure these never aren't removed? Appreciate any help edit: if it helps the 2 fields that are removed are both SUM of values

I'm I only really know basic excel but I'm trying to set up a spreadsheet to record football teams and results as games occur Arsenal win Man u draw Chelsea lose Arsenal lose Chelsea draw I then want on another sheet to record all this information by team i.e (based on the data above) to...

Yall have been amazing at the help!! Thank you so much! I was wondering if you could help with one final question: I am removing points from a scorecard but only want it to remove a maximum of 10 points (Even though they can potentially lose more) EX: If they have an A they lose 5 if they have...

Hi everyone, new forum user here with some knowledge on vba and excel. This has been a great resource for me to use excel effectively and am hopeful if someone can help me with a long time problem of mine; Format: Excel Online Code: Excel Formula I am trying to figure out a function that's...

Hey my fellow celly nerds, I'm wondering if you can help out. I need 4 simple, but related formulas. I uploaded a screenshot of the first page of my data here for you to quickly glance at first, if you would. http://we.tl/1n6sJdBRot It's just a wetransfer.com link, since there's no "browse"...