Hi,
I tried Sparkline for showing Actual Vs. Target in one single chart. But its showing up in two different cells. Is there any way that we can show both Actual Vs. Target in one cell using Sparkline?
I have attached the sample data for your consideration.
Kindly support. This chart will be...
Hi,
I came across a new issue in Circular Reference which doesn't say the cell reference in which there is a problem.
Please help me with the attached error message. I have many excels and very few cells without a formula. In this scenario, its very difficult for me to find without any idea of...
Similar to CountIF & SumIF, how good it will be if we have SumProductIF!!!!
Likewise, in data filter it would be of great help if we have an inverse selection option. For ex: if we have selected 3 out of 10 values in the filter and now we need to select the rest 7 values, its manual and time...
Hi,
I have a file with 10 sheets with formulas connecting to different files.
Of which, I believe the linkage is lost in 2 of the files, as they are not saved.
Can anyone please guide me on how to identify the sheet and the particular cell which has some reference to the 2 unsaved files?
The...
I came across a weird issue when I tried to find a cell value "80% ~ 100%". The problem is not with 80% or 100%. The issue here is the cell value has got the symbol "~" which Excel is unable to recognize.
When you change the symbol from "~" to "-", excel promptly finds the value.
This is so...
Is there any way we can inverse the selected vales in a data filter? Assume, we have 5 values in Column A and already filtered Values 2 & 4. I am looking for a solution whereby I should be able to select rest of the values like 1, 3 & 5 by click of a button.
Can anyone help with a macro or any...
Guys,
I need your expert help to show the relevant custom icons in Column C according to the values in Column B.
I have attached the file for moe clarity. Your kind help is much appreciated.
Regards, Ramnath
Everyone must have come across this Calculating issue when excel is filled-up with formula.
But I am wondering is there a way to find out which spcific cells are causing this issue? This is because, not all the formula cells are problematic. There might be very few cells containing volatile...
Hello Forum,
I need to update 40 line charts every month. Each charts will have 3 lines (Actual, Budget & Forecast) plotted from Jan till Dec. Due to intercepting lines, Data Labels will overlap each other which will not be meaningful. Hence, I need to have Data Label for Start of the year...
I would like to know the Cell reference of the formula where the result is matching. For eg. if the Vlookup formula is matching the cell C58, I would like to know that cell reference instead of the value.
Is there any way to find out the same? Please help.
Regards, Ramnath
We are conducting monthly survey and based on whether customer has a complaint or Feedback or Appreciation, we need to send a customised response to each one of them. It would be easy, if there is a drop-down at the end of each rows where the response can be categorised. Once when all the...
Hi,
I have a peculiar problem. I have created a userform and populating data in to it from Excel which is from a Access Database query. When I open the Excel file the form shows up and data is populating in a second. But if someone else is opening the same file, once when they click the "SHOW"...
Hi,
I wish to know if there is a formula in excel to find out similar sounding words even if the spelling is wrong. We need to match 2 names in database where there are spelling mistakes. Nothing is working out to know whether its just a spelling mistake or altogether a different word.
Any...
Dear all,
I have a new challenge before me to track changes in the Access Table which is controlled by an Excel Form. I browsed the below code and works perfectly well if the form is in Access. But I have the form in Excel. Can anyone help me in modifying the code to track changes in Excel...
Hi Hui & Friends,
I want to identify an existing record in Access and update a range of Blank fields with some value in Excel.
I tried for nearly 2 days but in vain. If anyone can help, it will be great help.
To give you more information, This is like a stage by stage application flow. 1st...
Hi,
Can anyone help me with a simple vba code which i can use to browse a file and once when selected the file should be saved in a default folder.
Regards,
Ramnath
Hi,
I need to query access Table and retrieve matching records by matching a variable supplied by the user through input box. The problem I face now is after several days of attempt to frame a SQL query, I couldn't get the result. I have given the statement. If anyone can help it would be of...
Dear Hui,
I have designed a small application using VB Form in Excel. I have protected all the Modules, Excel Structure & Excel Workbook to prevent the user to get in to my workings.
I have got some 4 buttons in the front screen to do the job and I am getting the below error message just...
Dear all,
Can anyone help me with a VBA code to resize VBA form (in Excel) according to the screen size which may differ from PC to PC?
Also I have one more requirement:
I have designed a form in Excel and I don't want Excel to show up even in a minimized mode. I just want Form to appear...
Hi Hui,
I need your help.
I was visiting the website where shortcuts were mentioned. I was trying to do some of them in a new excel book.
Suddenly, to my surprise the Column Headers which used to be in Alphabets A, B, C,... has now changed to 1,2,3,4,5.....16384. Meaning I have numbers in...
Hi,
Please help me in converting a number in to the following format.
Eg: 368002
Solution expected
300000
60000
8000
2
Eg: 300002
Solution expected
300000
2
Assumptions:
- The sum of the broken down numbers should be equal to the original value
- There won't be any decimals
-...
Hi Chandoo,
I have a peculiar problem. I want to show some data points which are for the previous months (not a part of the Current month’s Survey file) along with the current month Pivot table. I need to have Previous months data against respective Parameters in order to show the last month’s...
Hi Chandoo,
I have a problem in removing duplicates of Positive & negative signs in a same column. There will be only one positive & one negative with same amount. More than one in either of the positive & negatives are not possible. A sample of my worksheet goes like this...
Cell Type...