8th

  1. S

    Help sorting rows with dates greater than 14 days prior

    Hi, I have a spreadsheet with data pulled from an accounting system. The data reads as per the below example <tbody> Invoice Number Current +30 +60 +90 +120 Total Debtor Name Invoice Date 123456 0 10 0 0 0 Invoice Date 123457 10 0 0 0 0 Invoice Date 123458 0 0 10 0 0...
  2. JackDanIce

    Partial array slice

    Hi, Have a 2D array R x C in size, C max (column count) = 14. Is there syntax (without explicit ref e.g. arr(x,1) & arr(x,2) & ... & arr(x,8) ) to join first 8 columns per row? Psuedo code: myKey = LEFT(join(arr), 8)where 8 represents 8th column (not 8th char!) Ideally, without creating a...
  3. A

    Code to Select Pivot fields ( dynamic )

    Hello friends, I need a code to select the fields (Dates) in pivot (In Pivot- Value) Example: Below code will add 7th and 8th Jan'18 field to PivotValue. But Next Week it should select 8th and 9th Jan'19 automatically instead of 7th and 8th. Please help to get this fixed...
  4. D

    If found more than x characters in a cell, copy row, insert below

    Hi all Trying to do a bit of code where it would go thru the column and if it finds more than 7 spaces in a cell, it would copy that row and insert it under it I've tried something like this but doesn't work llr is last row Range("e3", "e" & lllr).SelectFor Each c In Selection c.Activate if...
  5. V

    Adding based on groups in excel

    Hi guys I want to add the sales number if the id is equal example: I want add 901 and 2994 if id is same in this case id is 40317 <colgroup><col><col span="6"></colgroup><tbody> 539 8th Ave 40317 40317 C N Y 901 539 8th Ave 40317 40317 E N Y 2994.5 </tbody>
  6. B

    how to calculate textboxes in a report?

    I have a report with 7 textboxes that are populated from a query. I have created a 8th textbox where i want to sum up the textboxes. the first 7 textboxes are short text in the table. the 8th textbox i want to write a formula so it takes the current value of the 7 textboxes and show me a total...

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