Good Point. But these data is exported from DB and I am importing as is.. Therefore I would like to find the discrepancies rather than trimming them in excel which hides the reality under the hood.
So without using the TRIM function, is there a way to achieve the results that I have asked for...
Hello @Chihiro, thanks for helping.
I would like to have the CF to Cell which shares different value.. For example text can be same in Cell K2 "English" but in K3 if it is "English " then it should not match as it contains trailing space in K3 therefore it is should not be considered as exact...
I am seeking assistance with applying conditional formatting to Row 2 of my spreadsheet. My goal is to compare values between Row 2 and Row 3 on a column-by-column basis. Specifically, I want to highlight any column in Row 2 where the corresponding values in Row 3 do not match.
For example...
Yeah, I apologize for the confusion and not mentioning all the rules in advance. I see the below condition fails if the column has no value and no space either in one of the row or both of the row. The are scenarios that the column is either blank in one of the row or both of the row, or simply...
Hello @vletm,
Thank you so much, I was looking for something like this. However, I observe a small challenge.. If the value in the column itself is different then also can it highlight somehow? For example, the value in C2 and C3 are now different and it doesn't highlight.
Also the number of...
The approach that you have suggested seems to be not helping in many scenarios.. The goal is to compare data in Row2 and Row3 and finding the discrepancies.. Lets say if there is a column (i.e A2) with a single space in it (i.e no data but a single space) and (i.e A3) with two spaces in it, I...
Is it possible to have different colors so that it would be easy to understand which portion of the text has extra characters?
For example if,
- Right Side of the Data has extra characters - Pink
- Right Side of the Data has extra characters - Green
- Both Left Side and Right side of the Data...
In the attached Excel sheet Data.xlsx, I have three rows including the column headers. However, upon closer inspection, I noticed that although the data in Row 2 and Row 3 appears identical, there are subtle differences due to extra spaces in the "Name" and "Country" columns of Row 2.
I'm...
Hello @bosco_yip, I have tried that already but the below step doesn't seem to have any effect.. I hope it should change the format of the date to (2020-10-21 12:20:00) instead it still shows (21-10-2020 12:20). Attached the sheet for your reference.
Select A1:A16 >> Custom Cell Format, enter ...
I would like to convert the dateformat in the attached excel sheet to YYYY-MM-DD HH:MM:SS
what is the quickest way? can this be achieved using a formula?
I am finding someway to group bubbles inside a bubble chart. Just looking for some inputs on that. I have attached an excel sheet with this message which contains the bubble chart.
The condition is, if there is any bubble that falls in the below range
- From -2.5 to -0.5 and 0.5 and 2.2 then...
I have attached an excel sheet which contains the information about all the Debt month wise starting from this September & October. The sheet will be updated every month with the updated information. Wanted to have some basic view on the added data for the month of September & October. Like how...
I wanted to find out days between two given dates (i.e G2). I have tried using the formula DATEDIF but for some reason it doesn't give me any results.
In addition, I would like to set colors to "Total Outstanding" Column (i.e C2:C5). If the Total Outstanding Amount is greater Credit Card Limit...
I wanted to randomize data to the maximum possibility for one of my testing purpose. Any help on this would be appreciated. I have attached a excel sheet with this message, which contains two sheets (Raw & Expected).
Raw Sheet contains the original data where as the Expected Sheet contains the...
@Marc L, thank you for all the help.
I have gathered all the possibility's without missing out anything and attached here. Could you please help me out? I am not quite sure about the parameter solution which you are talking about. So if you could show me an example with my current data that...
@GraH - Guido, thank you for helping me out. I am not sure which blog article that you are referring out. I couldn't find the right one to. Could you please point me to the right one if you have the link handy.
Also, it would be great if I can get one example for making pie-chart for my data...
Hello,
Please refer the attached excel workbook containing 3 columns.
Bank Account Number
Branch Location
Account Opened By Official.
Pie Chart
I would like to have a 3D Pie Chart representing Branch Location and how many accounts each location has.
Bar Chart or any other better charting...
Sadly this doesn't work. Either a VBA Solution / Non VBA Solution would do. I have around 500 excel files where I would like to remove sensitive information like Author Name, Last Modified By and other sensitive information from the workbook.
Any help would be appreciated!
Is there a way to remove sensitive information from excel workbooks? i.e like Author, Last Modified By information. I know we can remove it individually by inspecting the document but is there a global way to disable it automatically for all new excel files? Also apart from this two information...
@Hui, it helps and this is what it is needed. One final question.
AA1234567898616720
If I only wanted to generate the random numeric characters that are marked in RED color assuming the first 4 characters are fixed. How could I do that?
AA1234567898616720
Same for the above too, but if I...
@Hui, thank you for helping me out.
I see the random values are getting generated. But the numeric value is not of length 16 digits for all the records. In some it is 16 digits and some it is 15 digits. Any idea why is this happening?
I would like to generate 1 Million Random Numbers having a prefix of AA and having the number length of 16. For example it should look something like "AA1234567898616720". Is there a way to get this done via some formula in excel? Only one condition should be all the 1 Million data should be unique.
Hello @NARAYANK991, I understood now. One final question, how do you find that those are ascii characters? Also is there a quick way to list all ascii characters and their decimal values?