symbol

I paste my current cryptocurrency exchange order into column A. I use several macros on it then clear the contents for the next trade. So the contents of Column A changes with every trade. The problem I am having is now Bittrex puts the Bitcoin symbol at the beginning of the number like the...

In cell A1 I have a formula which comes up with either 0 or a number greater than 0. In cell B1 I want: 1. A tick symbol to appear if A1=0 2. A cross symbol to appear if A1 >0 Not sure how to do it or what formual would allow this as I have never dealt with symbols in formulas? Can this be done?

This is probably an easy one for you gurus, but it has me stumped. What I want to do is search for the ! symbol. When it's found, insert a row above it and insert some text. Then go to the next occurrence of the ! symbol and repeat until the end. I created a macro that would do this, BUT, the...

I have just upgraded to office 365 for Business All my formulae now contain the semi-colon symbol instead of the comma symbol and I have to capture a formula now using the semi-colon. Is this a setting I need to change to continue using the comma? e.g. vlookup(A15, A7:C14, 3, false) now shows...

Hi everyone, I am using the formula below on conditional formatting which looks up the staff name (R5), Matches it with the data in BD5:BD150 and if the adjacent cell (BE5:BE150) does not contain W then it highlights for me. =VLOOKUP(R5,$BD$5:$BE$150,2,0)<>"W" My problem is that I have three...

I'm creating a custom tab in my Excel workbook, using the Office RibbonX Editor. For the buttons that will be on my tab, I am using supertip to show a description of what the button does, if the user hovers over the button. In the text I want to appear, a character that I want in the string is...

I have a font which has graphic symbols that I what to use in Excel. The font works perfectly in Word, but in Excel it displays the font letter instead of the symbol that is assigned to that letter in the font file. How can I get Excel to display the symbol that is assigned to that letter?

Is it possible to have the following formula display thedifference between cell C15 and another cell? =TEXT(ROUND(C15,0),IF(C15,"#,##0","0")&""&IF(C15>C28,"▲",IF(C15=C28,"●","▼"))) The formula is useful as it shows the value of a designated cellalong with a symbol indicating whether the...

Is it possible to use the amend symbol (&) with a date and keep the date format? The purpose would be to create a unique identifier for Vlookups but the result is not user friendly. Example: A user could show up multiple times, their duties could show up multiple times, the only thing that...

Hello, Thank you for your assistance! I have a macro that applies a custom number format to selected cells. The number format works great within the workbook as: 0.00%" →";0.00%" ←" I'd like to apply this using a macro. The VBA window won't display the "→" arrow symbols. They are displayed as...

Excel 2016. Hello Excellers. Here is the 'stupid question du jour'... is there any way to loop through the list of currency options using VBA? I'm referring to the options when you format a cell, click currency and then you get a long list of options (currency symbol and region). I'm wanting to...

Hi there, I have two columns In the one column is a symbol and in the other an amount if the symbol in D = P then the amount in Column E should be negative. I then have a total box that will add and subtract the value's together. How do I insert a line automatically when I want to make a new...

Hi there I'm having a small issue with my email hyperlink in that what I have works correctly, only when there is no "&" symbol in the cell that the link is referring to. If there is an "&" symbol in the middle of the string, the hyperlink only extracts the part prior to this. Is there perhaps a...

Hi, I'm struggling with formatting values using VBA by using the standard accounting symbols. My plan is to take the information from a report that provides me with values and currency information in two separate columns. The currency is a three-letter code like USD, EUR, AUD etc. and I...

I have a shift schedule with symbol and legend with duration value of each shift symbol. I want to summarize the value corresponding to the symbols for each employee. Now I use: =COUNTIF($D5:$AH5;$A$13)*($N$13*24)+COUNTIF(D5:AH5;$A$14)*($N$14*24)+COUNTIF(D5:AH5;$A$15)*($N$15*24) where D5:AH5 is...

Hi everyone. I'm having a hard time trying to sort out an Excel VBA. I need to search column D and if there is not an @ symbol anywhere in the cell, shift the rest of the row to the right 1 cell and empty the cell without the @ symbol. I'm looking to see if the cell has an email address, if it...

Hello fellow developers. I would like you to give feedback on this macro I coded. educational value: the code contains comment lines to explain various coding techniques. Did it help to understand how some things can be done? Working with a dictionary Return multiple values from a function...

Hey guys! This is my first forum post in Mr Excel so hopefully I do this right. I am also new VBA so my apologies if this is an easy answer. I am trying to write a macro that deletes a row/cell if there are less than 3 characters before the "@" symbol or if the same letter is used repeatedly...

I have 2 worksheets. Sheet 1 has different data in column A and Column B Sheet 2 has the same data from column A:A but not in the same order and Sheet 1 Column B data is transposed to row from B1 I want to place a symbol (Wingdings 3 "p" which is a triangle) at the intersection on sheet 2 by...

Hello all, Can someone please help me with the following: I need to look at 3 cells then colour one of them depending all values. I.E. cell A1=10000, B1= 5.7 and C1=a symbol like >>. So i need B1 to change to green if A1= between 5000 and 15000 and B1 is less than 6 and C1=>> Thanks -...