collumn

I have an excel document that I get every month. I would usually type the formula =IF(Q3="I","Colonial FS Insurance","Colonial 1st State") into cell AB3 then double click the corner to drag down to the last row. The number of rows changes every month and can be anything from 30 to over 2000...

Hi, How can i get the first line value of the collumn with "1" value and print the result on the last column like in example above: <img src="https://i.ibb.co/R9WBhzq/Capturar.png" alt="Capturar" border="0"> Thank you very much.

Hi All, I am having a real problem with return the time of a cell using 2 criterias: This is the data table: A B C D 1 02/01/19 John 08:16 06:40 2 03/01/19 Bob 08:20 05:30 3 04/05/19 John...

Hi All, I wanted to ask if you could help me with two macro issues: They're both connected to this thread ( https://www.mrexcel.com/forum/excel-questions/1030928-create-new-workbooks-out-unique-data-within-single-column.html ) as I want to create a similar macro with few additional functions...

Hey Guys, What i basically want to do is the following: i have a huge chunk of data (Data!) in one spreadsheet and want to choose one specific Collumn from where to add the sum. Here comes the trick: i dont want the specific collumns to fixed i want them to be able to change for example from I...

Hello. I am new to Excel, I am learning it, but I can't do something. So the task is like this: I have to create 1 more collumn in right of "Comitat" named "Ecuson". In that collumn the name from "Nume participant" should be with uppercase(I guess by using function UPPER) but it should have...

Hallo, I' m trying to find a sollution to the following problem. I have a collumn with numbers (in the followin example collumn "Code"), which their lenght vary (from 2 to 10 digits). In another collumn (Collumn "Result from the formula") I would like to have a formula that will count the times...

Hi all, Please consider the table below. Is there a way do automatically set the order ignoring blanks? <tbody> Value Order A 1 B 2 C 3 D 4 E 5 F 6 G 7 </tbody>

Good evening everyone, I've just started working with Excel VBE and I've ran into a problem. I need a VBE solution to copy certain data from a collumn. For example a collumn looks like this: <tbody> Carlsberg Carlsberg Carlsberg ISS A/S ISS A/S ISS A/S ISS A/S ISS A/S ISS A/S...

Hi guys, Is there a way to pick out cells that contain text from multiple columns and aggregate them into one single list? eg: Problem: <tbody> red circle table square book Blue triangle pencil green </tbody> Result needed: <tbody> red Blue green circle...

I need a formula to change a color in collumn B,C,and D if the month/year is the current month or older. If it's the current month I want it to be yellow, and if its a past month I want it to be red. I hope this helps you guys.