I'm looking to search a table like the the one below. In a separate sheet in the workbook, I'd like to have the "Subject" as multiple columns and list underneath it all of the titles that match the subject and have the language in english. I tried working a combination of index and match...
I have a file that is shared with several people. Some of them have Spanish regional settings, and some of them English (I don't think there's anything else than those two).
The thing is that the file has a date column, and I have a format "mm - aaaa" which for those who have it in...
Is it possible to highlight cells based on another cell. That is a bit of an oversimplification. My table looks something like this:
How would I create a measure of a weighted average based on 2 different field values? I know how to do this in excel using SUMPRODUCT, but I'm relatively new to DAX and dont know how to do the same calculation that I would normally use in Excel.
For the below, in excel, I would use...
keyboard shortcut to open pivot tables old view is CTRL+D+P
what is the equivalent shortcut to be used in an excel spanish version ?
where can i find the list of keyboard shortcuts in english with their equivalences in spanish
Hi there - could someone please tell me whether it is possible in Excel 2016 to have English words in say column A and a Spanish translation row by row in column B? I presume it probably isn't possible as I can't see anything about it in help.
I need some help with this formula
How do I continue the formula if the cell A1 name changes to let say English or Spanish etc..
Thanks in advance
I am working on excel file that enabled VBA Object Model Through SendKeys for all English language users, SendKeys are not working for Users with Office Spanish version. I am hoping if anyone help in translating SendKeys to spanish version? I have placed my code snippets below.
Hola a todos,
Tengo una duda en excel 2003, la cual es probable que se solucione con una fórmula matricial.
Tengo una columna A con varias fechas:
I am currently working on doing some translations from English to Spanish. I have been struggling with finding a way other than "insert special character" to make the "n" with the ~ and some accents.
Does anyone knows where can I find the list of shortcut keys to insert those characters...