collumn

  1. T

    Help a newcomer to VBA. if statement or equivalent

    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...
  2. D

    Get value if "1"

    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.
  3. LaurenHancy

    VLOOKUP with 2 criterias

    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...
  4. R

    New worbook

    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...
  5. E

    Excel Spreadsheet access from other Spreadsheet

    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...
  6. A

    Can't find the good Formule

    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...
  7. S

    count based the number of digits

    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...
  8. R

    Adding values in collumn disconsidering blanks

    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>
  9. V

    Copying different names from one collumn.

    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...
  10. J

    Combining multiple collumns to create a single consolidated list

    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...
  11. S

    Formula for changing color.

    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.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top