info

  1. M

    Extract information from cells

    So I have a column with information like this: XC-163 0827m Timber problems 0600m failed picture cv-76 ligts out 0987m p3 etc What I need is to create a column only with the measurement info in it which goes behind the m, in this case: 0827 0600 0987 Any ideas of which functions I can use...
  2. M

    Excel calendar

    I am using this Excel calendar https://support.office.com/en-us/article/Excel-calendar-templates-F2E7FFE9-41FA-4CE5-8278-CF92D3B66340 and while it seems OK, it is a pity that info added to specific dates is not copied through to same dates when modifying the year and saving it as a new year...
  3. E

    few cells info in one cell

    Hello, I have such info in a table (provider, purchase order nr, date when it has to arrive , comapany inside code for this part, part numeber(providers) quantity <tbody> MOUSER ELECTRONICS ( ES) ERGR180829-1276 2018.09.17 0 12R-00548 MMSZ5246B-7-F 10 </tbody> and info from...
  4. A

    sumif formula with conditions

    Goog Day, On cell C41 I want to put a formula which will calculate the total sum with the conditions below. I've created a table from B6:D40 There will be numbers from B6:B40 and C6:D40 will have the letter info as X My target is to get the total of those numbers.But if there is no info on...
  5. J

    query help on calculations

    Have three tables: Project, materials w/qty and material cost. Project and materials have a relationship. I want to build a query where the info from these two tables can show the info and the material used will go to the material cost table find the cost of that material multiply it with the...
  6. W

    Need some guidance on a challenge

    Dear Forum, I need some help as I have no idea how to tackle this challenge. I have data in the following format (about 7000 records): <tbody> User Project Code Transaction Date Hours Allocation Category </tbody> and need to do some calculations on it, and present it in this...
  7. R

    help with VB

    I am looking for something if I have formula 7cells from A1 to G1 pulling info over. If one of the cell do not pull info over an it delete the row or line. like if info does not show up in cells D1,E1 and F1 Help please
  8. A

    sharepoint login popup

    I have a process where it loops and opens thousands of excel files and then copies each tab to a blank spreadsheet. At some point when it opens the file, it prompts for a sharepoint login. How can i disable it so that it does not prompt me for that info?
  9. M

    Adding More Conditions to an Existing Formula

    I have a formula that currently works correctly that is located in cell L2: =IFERROR(VLOOKUP(B2,'Site Assignments'!$A$1:$D$131,4,FALSE),"ASK JON FOR INFO") Now I want to add logic that says if cells F2 and I2 are blank, then leave L2 blank I think what I need to add to the formula above is the...
  10. D

    Looking up 2 tables

    I have a cell that needs to lookup two tables to find the price. It needs to lookup the time of week (such as mon-fri, weekend or public holiday), type of service and type of location (metro, regional or remote). I have two tables to show this info but is there a formula that allows you to...
  11. H

    Copy same info to the another sheet VBA

    Hi, Please see below code. When I run macro, info copying to sheet1. But I need at the same time to copy same information to sheet2. Please help. Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Sheet1") ws.Cells(iRow, 2).Value = Me.combobox_name.Value
  12. Y

    Formula that skips rows when Copy Pasted

    In the "stats" tabs, I am trying to add info to each row for each employee. In the "Document" Tab I want the info from "Stats" Tab to populate but when I copy the formula down I will skip about 33 lines in the actual sheet. For Example: "Stats" A2= "document" C2 "Stats" A3= "document" C15...
  13. S

    Unable to completely unprotect workbook

    Hi all, First of all many thanks for all the good stuff on this forum! I'm using this forum for a while but can't find the answer to my problem this time, thanks for your help! In my macro to protect I use: ThisWorkbook.Protect Password:="BlaBla!", structure:=True, Windows:=True To unprotect...
  14. E

    Excel Formula Help

    I am some what new to sheets but know it is a very powerful tool. I am trying to total from one sheet to another. I also am trying to separate the total by phase and month. I also need to be able to add info to other cells based on the info in one cell from data validation. I have attached a...
  15. shaftdx

    V Lookup Wrong info

    Hello I have a problem with the Vlookup feature, Kinda...I figured it out how to get the information in there but it is grabbing the wrong Info. I will start off by explaining the kind of information I have going on here. I work for a school bus company and we do alot of trips. I want to be...
  16. S

    Complex formula creation

    Hi there I am looking to create a formula to pull the total amount of people in a certain department and their salaries. All this info is in my data tab but I do need it summarized on a different tab
  17. K

    formula for mailto + cc

    hi everyone, trying to get this formula to work properly at the moment i have this formula - that pretty much hyperlinks a cell to open up outlook to email to cell A2 and cc cell a3 =HYPERLINK("mailto:"&A2&"?cc="&A3, "NAME" ) Issue I am having is that I'd like to be able to display "NAME" as...
  18. S

    How to set a vlookup with missing numbers

    I have a spreadsheet that lists all of the items I need to order. They are in numerical order but some items are not needed so they are not in the range for the vlookup (picture 1). #1051 is missing. Since #1051 is missing, it duplicates the amount in #1050 (picture 2). I get that it has...
  19. T

    If Statement Problem?

    Hello, I am trying to make this problem as easy as possible. I am trying to get the values for MCA(Maximum Circuit Ampacity) and MCOP(Maximum over current protection), this values depend on the info ask for; fan HP, electric heat(7.5kW or 15 kW) , voltage and phase. I set up a data validation...
  20. H

    copy numbers and text to separate colums

    hello, I have a a file which has info such as qty and description of items in the same column. I need to separate the info into two different columns or at minimum copy just the starting numbers to a separate column. The info is usually in this format with the info needing to be extracted or...

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