figures

Dear all, I have a simple and yet complicated question. I have a bar figure with three years for 13 countries. Here it is: for each of the countries, and for each of the years, I also have another data (growth rate, if you are interested), that I'd like to plot as a point. So, take for example...

Hi, Due to the fixed column width the figure more than width is showing ###### and need to double click to see the figures, how column adjust itself automatically ? <colgroup><col></colgroup><tbody> </tbody>

Hi, I received 1 excel file contained values but having 2 or 3 spaces after figures, I think this is formatting issue, what formula can I apply to get figures only. In the below example x means space Current figures 100xx 300xxx 210x Wanted 100 300 210

Hi, I've got $ figures in range I14:T20, and each respective column has a subtotal formula=SUBTOTAL(9,I14:I20), =SUBTOTAL(9,J14:J20), etc The user can run a macro to insert a line at the bottom of the data which will then be populated with $ figures. My question is, when the row is inserted...

I have a donut chart that won't update we the figures change. it used to but now it has stopped doing it. I've redone the chart and updated everything twice and it still won;t update when the numbers change. The numbers are based on formulas (i.e. I don't change them manually) - even if I...

Hi, I have a databook with a large number of tabs that we use check figures to ensure consistency from tab to tab. These check figures are just a simple sum function that also subtracts from another tab's subtotal and when everything is working right, should sum to zero. For example, a check...

Hi Mr Excel, I need an alternative to filtering. Something like grouping that will give me a handy button on the lefthandside... I understand groups. I select three adjacent rows and do shift-alt-rightarrow and a button appears on the lefthandside allowing me to open or close. But what if the...

I am setting up a spreadsheet to collect monthly figures. Of these figures I want excel to automatically calculate a percentage using two figures. I have this formula just fine. I want to have the formula present for all future months so that when I input the figures it automatically calculates...

Hi all, I have a userform with some textboxs that are linked to some cells in a sheet of Excel. Here is the code of the userform Private Sub UserForm_Initialize() TextBox1.Value = "" TextBox2.Value = "" TextBox3.Value = "" TextBox4.Value = "" end sub And here is the code of the command...

Hi Experts - Please give any formula I want to get the figures in row 3 for each month based on selection of month in cell A1 as per the given example below, in Mar and Apr figures are showing zero Suppose if I select Mar in A1 only Apr should show zero rest of the months should take sum from...

Hi, I currently have graphs which compare last years figures to this years figures. However I report on these monthly and do not want to show what the figures are from last year for future months, I only want to compare form beginning of the year until now. I have all the data from last year in...

Hello Everyone, I am making a cricket database for a team having a problem with grabbing the best bowling figures from data. see below example. in cell B4 should be the player took the maximum wickets in all matches which are 3 wickets in match3 by giving away only 15 Runs. so in A4 value...

Hi, I tried ungrouping my data and then inserting the calculated item. Which worked. However, when i try to group the data back in terms of monthly figures, it does not allow that. Could you kindly guide and advise a way to add a calculated item and still have data grouped month wise rather...

<colgroup><col><col><col><col><col><col><col><col span="2"><col span="2"></colgroup><tbody> Ledger No: ID# Src Account Name Date Memo Beginning Yr Balance Debit Credit Cl Daily Bal Cl Mon Bal 4-1100 GJ000327 GJ Sales 30-Sep-16 PayPal US Transactions 0 $77,477.73 ($122,046.23) ($122,046.23)...

Hi Folks.Hoping somebody here can point me in the right direction or provide a little assistance with a little quandary I've now found myself with.I run a daily KPI sheet for various sections of my workplace and we have a rather large workbook (30+ sheets) that runs myriad of statistics for a...

Here is my problem: I’m trying to create a macro to find & replace certainrows of text in an Excel worksheet. Example: <tbody> 5710 Electric in Pasture (CLAIM 100%) 0.00 Dr </tbody> Replace with: <tbody> 5710 Electric in Pasture...

Hi everyone! New to the forum so apologies if this has been covered. I am seeking help on how to match data from a report exported from sage and converted to csv to match another excel spreadsheet. So I have an excel master spreadsheet with names of customers with their monthly sales figures...

This can't be complicated... I have a huge amount of cells with figures already inputted into them. I would like to simply add a percentage to those cells. Thanks a bunch L

Hello, I did formatted the textboxes values likeTextBox9.Value = Format(Now(), "h:mm") TextBox10.Value = Format(Now(), "h:mm") And i'm trying to find the total minutes between eachother by manually changing the values... My question is after 24:00 calculation gives me wrong figures with the...

Hello, Could anyone please help, I have last years sales figures month by month and this years sales figures I would like a formula to compare sales percent increase or decreases per month and add a minus highlighting the percentage decrease Many Thanks for your help and advice Cheers