means

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

my data is <colgroup><col><col><col><col><col></colgroup><tbody> Pos 0 Subs 1 subs 2 sub Sub 1 1 2 2 1 1 3 3 1 2 5 </tbody> 1 subs- 1 pos and 2 sub then in 1 subs ZERO and in 2 sub its 1 1 subs-1 pos and 1 sub then in 1 subs 1 and 0 subs its 1 2 subs-2 pos and 2 sub then in 1...

Good day MrExcel First off, thank you for taking this time to open and read up until this line... now my problem st I previously posted a question similar to this here in MrExcel and it was resolved by user <strike>AliGW. </strike>Now, I have encountered a project which has a different...

Hello, I need your help please, i am looking for a vba code to parse following aviation weather message and compare some contents instead of doing it manually: weather criteria 251544Z 2518/2624 23015KT 9999 SCT020 TN18/2608Z TX26/2617Z BECMG 2522/2524 29007KT BECMG 2606/2608 35005KT 7000...

Hello, can someone please help with this... I'm trying to get excel to IF function to return to words to W and L without having to manually type it in. Here is an example below. The forecast means, +16 play the over to win and -11 means play the under to win. basically any plus symbol play over...

Hi, From a RefEdit on a UserForm, I get a range containing multiple columns, let's say Sheet1!$B$4:$E$13. Another value tells me which column I need to focus on. So if the value is 2, that means the second column in my range (Column C). I'd like to get the code that will return...

Hi everyone. I just registered to ask the gurus here for some help. I'm trying to make a system to record the attendance in some classes. These classes can either be in group (most common) or individual. When a student misses a individual class and attend one in a group (exceptional) in a way...

Hi MrExcel, I have a table like this : <tbody> Group Increment 1 1 1 1 1 1 1 1 2 1 2 2 2 1 2 2 2 1 2 2 3 1 3 2 3 3 4 1 4 2 4 3 4 4 4 1 4 2 4 3 4 4 5 1 5 2 5 3 5 4 5 5 </tbody> Basically a group is in the first column. Group one means...

"=IF(SUM(AI107:AK112>17),1, "x") When I enter this into cell AL107 I keep getting #VALUE Have tried to get the same result ie a result, using various means without success. Thre's probably a simple solution which I'm not seeing. Any help appreciated.

Good morning community! We now have new requirements in the corporation, which makes data protection regulations a little stricter. This means that executives are only allowed to receive data, which is also assigned to the area. Previously, the records were exported from an Access database...

Hi all, Is it possible to conduct the following checks in the order listed? 1. Is the first character a number or letter, if it's a letter, is it capitalised? If it's not capitalised, it needs review. 2. Is any character after any space capitalised and the following character not capitalised...

Hello guys, I have an audacious project in my mind. I want to draw a 16 colour bitmap file in VBA. I want to draw the messages af an LCD display that has 5 lines of 30 characters The file has a size of about 170Kb. I wonder what are the limitations of VBA. Furthermore, is my hardware going to...

Help !!! i've just received new templates of my reports and i don't have any idea what does it means. the formula says =J9/H9/(J19/H19) .. i wanna know what does H9/(J19 part means. if anyone can help me, i would be very grateful.

Hi, I have the sheet with time measurements written as number and need to convert it to time format. For example 3,40 means 3 minutes and 40 seconds. How should I do it?

Hello Mister Excel, How is Madam Excel? :rofl: Sorry. :stickouttounge: I have a problem with a list of data in column A and B. <tbody> A B A C A D B A D Z E A F E G H G I R S </tbody> As you can see A = B = C = D and then D = Z and E = A so it means that A = B = C = D =...

I have the following table which extends to 1000 rows. Starting in Row 5, I have 10 data in columns K through T. I have specified a number in Cell F1 (could be 2 to 10). Based on that specification, I want a formula for Col I that calculates the average based on the specified number of columns...

I have to pull customers flight information from a website and paste it to my sheet but when doing so it puts all of the information into 1 cell. I have tried delimiter function but its hit and miss. I have tried variations of code and formulas but its just a big mess. What i need is to be able...

Hello all, i have really quick question. Does anyone pls know, what means "k" in formulas in Excel? And I dont mean function of it, I know what it is and what it does...I would like to know, what word is hidden under the "k" shortcut... :-) I was trying to search everywhere and did not find...

Hi all, Need to extract correspondence value from a range, my data look like this. A A1 A A2 A A3 B B1 B B2 B B3 A & B are depart and A1,2,3 and B1,2,3 are designation, what I want is when I'll put A (means depart name) in seperate cell, all correspondence value should show in very next...

Hi I am trying to understand custom excel number format. So I am reading the article below. It says # is digit placeholder.... What does that mean? what does placeholder means here? Thanks https://support.office.com/en-us/article/Number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68