limited

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.

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

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

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

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

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

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

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?

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

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

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

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

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.

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

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

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

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

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

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

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