Logged to UserVoice Dec 5 2016 - Spelling Mistake in idMso1 vote
It's been known for years that the way Excel deals with circular references is very poor. Under certain circumstances, you pop up a warning that one or more circular references exist, but none can be found and fixed. I'd be happy to get a list of fields that contain the error. If the system rechecks and finds another circular reference, I could then dispose of them quickly and keep trying to save until I succeed.1 vote
Need to include calculated (and dynamic) references everywhere where appropriate:
COnditional format influencing regions
etc ...1 vote
very simple,VLOOKUPs are case insensitive, VLOOKUPS should be case sensitive. One use case are Salesforce reports. They produce 15 character Ids that require case sensitivity functionality in order lookup against.5 votes
When using XLOOKUP to find information on another worksheet using the worksheet TAB as a dynamic-selection via the Indirect-function, the need for this argument becomes clear. For example; XLOOKUP(@INDIRECT("'"&$J$13&"'!$C5"),INDIRECT("'"&$J$13&"'!C5:H30"). the 'Tab-Reference' is the INDIRECT("'"&$J$13&"'!) part of the function.1 vote
The use of the TRIM function within an IFS function throws a #VALUE error, if the string within TRIM is longer than 255 characters:
if you use 255 instead of 256, the function works fine. If you use REPT alone, there's no problem.
Tested on German Excel version 1910 Build 12130.20390, monthly channel.1 vote
which seems clunky and complicated.1 vote
In the MICROSOFT EXCEL program - the function of blinking the
cell, and setting the color (under a certain condition IF)1 vote
I use the DATEDIF formula regularly for business tasks, including calculating due dates etc. I don't understand why this formula isn't more prominently offered to those who wish to use it.1 vote
A command that searches for file locations (like for the location of a PDF) and displays the file location
I have a mail merge tool that will grab a file and attach it to an email, using the file's location. But it'd be nice for there to be a command that will search a drive and FIND that location, so I only have to save a file once1 vote
Hi like i have entered few values in a formula & out of that one value i want to change the colour of that value so that i know this coloured values signifies me where i got that from. i can select that vales but didnt allow me to change the colour of that value.
I am organising ammunition from a list of my ammunition into different storehouses. They must comply with many regulations and not all ammo can be stored together. I want to be able to type in a storehouse number in an end column. When this number is typed in i want the data from that row of the table to be copied into another table that represents the storehouse contents. This way i can quickly move ammo across between he storehouses without having to copy and paste each time. I experimented with an =if function, but i couldn't find a way to move a complete row into a different table.
I am organising ammunition from a list of my ammunition into different storehouses. They must comply with many regulations and not all ammo can be stored together. I want to be able to type in a storehouse number in an end column. When this number is typed in i want the data from that row of the table to be copied into another table that represents the storehouse contents. This way i can quickly move ammo across between he storehouses without having to copy and paste each time. I experimented with an =if function, but i couldn't find a way…1 vote
I have to use a OFFSET fuction for a dinamic array and I was thinking is a good idea have the posibility to use a new function for detect the last column/row in an area like in VBA. Something like:
where RIGHTEND be like
=RIGHTEND(cell_reference,0 or 1 can be right or left)
Same case for DOWNEND
= DOWNEND(cell_reference, 0 or 1 for up or down)
It can be vey practical.
I had a 30x100 grid with 2 colors and I wanted to count how many cells there were of each color in each column. Filtering did not work as I expected it to and it would have been so cool if there was just a formula for it, though I can see how it'd be difficult to implement.1 vote
essa formula só considera 15 caractere e despreza os demais conforme exemplo anexo1 vote
I believe that a comprehensive conversion function for "Decimal Feet" to "Feet and Inches with Fractional inches" would be very welcome.
I believe that a comprehensive conversion function for "Decimal Feet" to "Feet and Inches with Fractional inches" would be very welcome. Input would be decimal feet, output would be feet, apostrophe (standard abbreviation for "feet"), integer part of feet, and fractional remainder reduced to nearest 1/2, 1/4, 1/8, 1/16, 1/32, or 1/64.
Example: 10.70833 would convert to 10' 8 1/2"1 vote
Named Range fix required due to re-occurrence of previous issues in Excel 2016
This relates to named ranges being lost when duplicate names used at scope workbook and worksheet used between linked workbooks.
I have examples of files where the order that workbooks are opened affects whether named ranges appear/disappear or not and hence whether formulas work or return errors.3 votes
I think it would be easy and cool if Excel had a Kelly Criterion function. You would only need two inputs from the user (potential profit as a percentage of wager and percent chance of winning). This would allow Excel to return the percentage of bankroll to risk.1 vote
- Don't see your idea?