cad

  1. A

    Data Validation List based on Cell Value

    I have a table in which currency in A and values in B <tbody> CAD 2 USD 13 AUD 15 CAD 5 CAD 11 </tbody> I enter text CAD in C1 and make data validation list in D1. Based on text in C1 data validation only shows the value against CAD. like image attached.
  2. E

    How to combine two table information?

    Hi, Can someone please help me with this: I have a table with these columns: <tbody> Product Original currency Jan-16 Feb-16 ... Dec-16 Total 2016 in original currency Total 2016 in CAD A USD 3 5 8 XX (3*1.3)+(5*1.28)+...+(8*1.294) C EUR 3.4 3.2...
  3. 2

    Multiple ISBLANK Query

    <colgroup><col><col><col><col></colgroup><tbody> ORDER STATUS CAD PENDING DIE PENDING STONE PENDING CAD PENDING </tbody> These are my 4 columns, if (Column 2,Row 2) -> CAD pending cell is blank , then Order status(Column1,Row2) should show CAD PENDING, if (Column 3,Row 2), DYE PENDING is...
  4. I

    VBA is *not* empty

    This code works for empty cells How can I amend it to work when the cells in column C has a value of "No" for example? Many thanks Sub System_Check() Dim cell As Range, c As Range, cad As String lr = Cells(Rows.Count, 1).End(xlUp).Row On Error Resume Next Set cell =...
  5. L

    Listing the values that were added by COUNTIF/SUMIF or gettign the summary of the values (

    Hello, I have an excel with a lot of data (attached excel is just a small portion of it). In this excel, my primary objective is to find the EFFORT by each RESOURCE to each PROJECT. If i use SUMIF, i get the total effort for each resource easily. However, I want to know list the PROJECTS and...
  6. R

    sumifs dynamic critiria

    So i have a drop down (B2) that is fed from COL 1 of the Help table Depending on Which is selected my SumIfs either has no criteria (All the whole dataset), Region (Use Col 1 of the data Table and only add matches) Region-District (Use COL 1 & COL 2) Col M = Sales A dynamic Criteria based on...
  7. X

    Two filters to select values and paste unique in another sheet

    I have data as below Currency Location CAD 00002 CAD 00004 CAD 00005 CAD 00002 USD 00001 USD 00002 CAD 00006 CAD 00004 CAD 00005 USD 00001 I want to filter for CAD, then select the Location...
  8. G

    CAD/DWG en Excel

    Has anyone experience with EXCEL and DWG? I want to select (with mouse) an object in a DWG-file. This selected object i want to drop in excel, where i can see the information. I don’t have a CAD appliction, like ACAD, installed. Please help me.
  9. G

    CAD/DWG en Excel

    Has anyone experience with EXCEL and DWG? I want to select (with mouse) an object in a DWG-file. This selected object i want to drop in excel, where i can see the information. I don’t have a CAD appliction, like ACAD, installed. Please help me.

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