User Profile
Savia
Iron Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: SImple Pivot Table Question
ShochuTaka It sounds like your dates are really just additional row labels. Add them to the Row Labels field. You might need to go to the menus and change to Tabular layout and turn off subtotals to get it looking right. Then you can just right click on a date and Group to group in the way you talk about.1KViews0likes1CommentRe: Excel formula not working in some cells
Baja2020 That's the correct result - 10/120000 = 0.0000833 = 8.33*10^-5. It's just showing in scientific notation as it's very small. By the way, your column header says these are percentages, but they aren't - try changing to percentage format from the Home Ribbon.980Views0likes2CommentsRe: Ranking in Excel
RichardBeavers Could you explain what you need to do and where a little more? I can't quite follow. One thing I immediately noticed - your XLOOKUPs refer to a range that has no $s in it - that means that as you copy the XLOOKUP downwards, the lookup and return arrays are also moved downwards, which will cause errors. Try e.g. N$4:N$500.1.2KViews0likes4CommentsRe: Formula Question
Tracie_Barker You can do this with a relatively simple INDEX MATCH - I have made an example in the attached file. I have referenced entire rows here to allow you to add more data later; if you don't need that functionality you should consider replacing with references only to the cells you are using.945Views0likes2CommentsRe: Ajouter une donnée fixe sur toute une série de chiffres (différents) dans toute une colonne.
Arnaud31 You can do this with a formula: =A1&"/00" This will make your cells into text. If you want to keep them as numbers, change the format to a custom number format with Ctrl 1; a format like #,##0"/00" should work.48KViews1like1CommentRe: Conditional formatting using tolerances
MicLima Yes, this would work with the rule I wrote as-is. The only difference is that I assumed that your negative tolerances would be expressed as positive numbers (your original example had a 0 negative tolerance so I couldn't tell either way). Fixing for the correct sign: =OR(D3-$A2>$B2, D3-$A2<$C3)11KViews1like4Comments
Recent Blog Articles
No content to show