limited

  1. R

    Zeros in a cell

    Hello, How can I keep different numbers of zeros in a cell, for example, 000 or 000000 or 00000000. When I use custom format, I am limited to the number of zeros that is customized but I need to have different number of zeros in a column cells. Thank you.
  2. A

    limited the formula !

    Dears, i need to limited the below formula and make it working automatically when i increase the column the row increasing after divided it i used the below formula =INDEX('[TESTSHeet.xlsx]Customers INFO'!$B$2:$B$201,ROWS('[TESTSHeet.xlsx]Customers...
  3. E

    How to lookup values from different column and return result

    <tbody> BOTTLE BOOK PENCIL PEN NAME RESULT ABC LIMITED INC CORP ABC LIMITED ABC LIMITED BOTTLE SNC CORP XYZ LIMITED OEM BOOK ABC LIMITED LIMI VENDOR PEN </tbody>
  4. B

    Macro to link data from non limited number of file to a common Excel Data base

    Hi, I would like to connect non limited number of Excel sheets (Project Management Sheets) to the same Excel data base, to be able to have a quick update on project status, for reporting. The difficulty is that the number of project is not fixed (5 more every months), projects managed by...
  5. M

    power Query Premierleague.com

    Hello. I am a football Stats man, and I have been trying to run a PowerQuery using my very limited knowledge with even more limited success! For example on this page : https://www.premierleague.com/stats/...s/goals?se=210 I am looking for this information here: It is struggling to find any...
  6. M

    power Query Premierleague.com

    Hello. I am a football Stats man, and I have been trying to run a PowerQuery using my very limited knowledge with even more limited success! For example on this page : https://www.premierleague.com/stats/top/players/goals?se=210 I am looking for this information here: It is struggling to...
  7. S

    Dynamic selection of column by header name and pasting the whole data into next sheet

    Dear All, I am working on an excel sheet which has 14 to 15 columns ofdata and I would like to copy some of the columns (according to the headername) and paste it to the next sheet. Sample below: <tbody> Reviewed by PACE Client Name Sub Engaging Parties DUNS Number GFIS Client ID ABCD...
  8. E

    Time limited use of excel sheet

    I would like to be able to allow time limited use of some spreadsheet files I provide to some of my clients. Is there a way to let them download one of my files with, for example, a 6 month password, or a 6 month expiration of the sheet, unless I supply a renewal code?
  9. B

    Find duplicate from similar text

    Hi, I have a long list of uncleaned data of account names with similar names. See below example. 1st col below shows that there are 5 accounts, but after manual adjustment line by line, there are only two accounts namely ABC and Foser. Is there anyway to use formula to remove duplicates...
  10. JackDanIce

    Data blending/fuzzy logic?

    Hi, Couldn't decide if this room or the General Excel and other programmes room was where to post; apologies if in wrong place. Looking for general comments/experiences for following: I have a table of data (~10k rows) which needs to be grouped by client name. Data entry has been entered by...
  11. S

    How to Freeze Share holdings (Quantity) as per debit balance

    Hi It would be grateful if anyone can tell how to calculate QUANTITY to be freeze depend on the Debit Amt. How can we automate in Excel for repeat client code basis as shown in sample column for Freeze Qty & Freeze Value (should be as per debit amount). If holding value is more than Debit amount...
  12. M

    Formatting a Measure is limited

    I created a DAX measure on Excel 2016 and right click edit the number formatting option is quite limited. For example, for negative if I wish to display (1,234) that seems not an option but instead only -1,234 is possible. Is there an alternative way we can achieve a custom formatting on it ...
  13. W

    VBA getElementsByClassName .. Innertext

    Hi, I am successfully able to pull text from a section of a web page into a string variable, but I seem to be limited to ~1016 characters. Any ideas what might cause this? Thanks.
  14. R

    Extract words of a certain portion

    Dear Friends, I have few words like the following: * ABC LIMITED * ~~TIN : 58976532147 * XYZ (P) LIMITED * ~~TIN : 25648793251 I want to extract only ABC LIMITED & XYZ (P) LIMITED Pls provide me a formula. Regards RAMU
  15. K

    Best way to copy data from Excel to SAP

    Hi all, I would like to ask what're the best MACRO options out there to automate data into SAP system. The primary focus is to copy a bunch of data (from excel) into SAP Vendor Master Data (XK01) automatically. Based on my limited knowledge, these are the only options I'm aware of: SAP LSMW...
  16. A

    Extract numbers out of text strings

    I need to analyze a list of 200 such excel entries daily. These are Text strings in each cell. A1: MANDAL FIN. CO. LTD SR- SD52 8.8 NCD 15JU27 FVRS10LAC|INE121A08OC|8.80|15-Jun-2027|100.250|100.2813|8.7360|500.00|- A2: CORPORATION LTD. SR-I 7.69 LOA 16JN23...
  17. M

    Help!!

    Hi, I am brand new to this forum and not sure where to post this so forgive me if i did it wrong. I need help with a formula for a rate card for my job. I need Excel to calculate dollar amounts based on footages. The criteria are listed below. I have tried everything I know based on my limited...
  18. A

    Position of number or a character in a text string

    I need to analyze a list of 200 such excel entries daily. These are Text strings in each cell. Entire string is in Cell A1,A2,etc for input '|' is character in the string. A1: MANDAL FIN. CO. LTD SR- SD52 8.8 NCD 15JU27 FVRS10LAC|INE121A08OC|8.80|15-Jun-2027|100.250|100.2813|8.7360|500.00|- A2...
  19. Welsh Mark3

    A diffuclt formula (for me)

    <tbody> Company Name<strike></strike> Group ID<strike></strike> <strike></strike>PM Account No<strike></strike> <strike></strike>Value<strike></strike> <strike></strike> <colgroup><col></colgroup><tbody> Desired Result </tbody> <strike></strike> <strike></strike> ELUMATEC USA...
  20. S

    Merge two excel spreadsheets using a reference and return the notes field

    Hi can you help, I have two spreadsheets that i need to merge on a daily basis. Copy below. The number field is the unique reference. What I would like to do is find a formula that can look at the reference number in the master spreadsheet find the same reference number in the daily excel sheets...

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