Re: Highlight Cell If Surrounding Cells Are Close To That Cell Value
Quote from WigiWhy A9, A8,A7, A13, A14,A15 and not A10 & A12?
It is a trading method that I use that has to exclude the immediate cells 
If we include the cells, is there an easy way to do it?
Hi
how can I create a formulae that
Highlight a Cell IF
Its surrounding cells are
+1 or +2
-1 or -2
away from that cell value.
Attached a file for example.
Thank you
Re: Total Up Different Groups Percentage And Present Them In A Table
but it does not group them together? I want to group Class A together and give me the total percentage - Group B together and Group C together
How can I add up the above and give me a total of their classes when the classes and percentage will change all the time
Please have a look at the Excel Spreadsheet attached.
Hi
I am trying to create a spreadsheet to keep my customers data and whenever I call them, I would like to update it in Excel with the comments and remarks of what I spoke to them about.
However, is there a easy way to Time and Date stamp each cell on the last update Date and Time? Perhaps in the Comments ?
Hi
Please take a look at the example given
I have a whole list of fields that I wish to combine into a certain string,
As there are too many fields including all the , ' ; etc Concantate may not be able to do it ....
Re: Delete off all blank rows in a spreadsheet
I pasted it in the macro editor but how do I run it? Does not seem to do anything
How can I delete all blank rows in a spreadsheet without sorting the data as I want it to be in the exact order it is in.
What formulae can I use in excel?
Re: Extract data from things in this spreadsheet and format it
How do I extract the URL from the link? Which formulae do I use?
Re: Extract data from things in this spreadsheet and format it
how do I reference the picture?
I have attached an excel spreadsheet
Could anyone tell me how to set a macro to extract the following datas from it.
Game Title
Description
URL
Picture can be set at 1 side to the right of the URL
How can it be done?
Thank you
Re: Insert SWF (flash) file into spreadsheet
Hi
Can no one help on this?
Re: Insert SWF (flash) file into spreadsheet
Anyone can help on this?
Hi
Can it be done? Example posted. How was the SWF file inserted into Excel?
Link to the file is at: http://www.onlinebookforsale.com/swfinexcel.xls
Please advise.
Re: Postage Calculator using Vlookup on a Table Array
Yes perfect except that I need your help again. Thought I could edit the code myself but Indirect seems to complex for me to comprehend.
Could the Zone 4 be changed to just Number .... Like a 4
And also .. Instead of just 2 zones I have a new excel spreadsheet with 4 zones.
Thank you once again for the help
Here is the new attachment
Re: Postage Calculator using Vlookup on a Table Array
Seems like I have not attached the sheet
Hi guys,
Need help in my excel spreadsheet.
I am doing a postage calculator to calculate postal rates for posting.
However, I am facing some problems
In the Main Sheet, Postal rates, I need to do something
1) We are divided into Zones - 1 to 4
Can I do a Variable that if I type Zone 1 and it will Vlookup on Zone 1 sheet and if I type Zone 4, it will Vlookup on Zone 4 sheet
2nd problem is that:
The postage needed: When I did a Vlookup, when I key in 55, it will select the wrong price table, if you take a look at the attached spreadsheet, 55g for Zone 4 it came out $2.05 but it should be the following rate which is $2.40.
Please assist.
Re: Download my eBay bidders email address
Lolz ..... ahha how about using a default username and password ;p
Re: Download my eBay bidders email address
Hehe although I am not too sure what is wrong with me collecting my bidders email address but its ok If there is anyone that can help, just let me know hehe norie - we have difference in opinions.
