Does the iPad version of excel allow for 2 variable data tables? I have a workbook with 1 and 2 variable data tables that are not updating. Similarly, is there the equivalent of an f9 key for mobile Excel?
Hi guys,
I am using this string =IFERROR(VLOOKUP(B:B;H:I;2;FALSE);"not found")
1 Example:
In column B I have following text: Ipad 6th Generation 32gb Space Grey
And somewhere in column H i have following text: iPad 6th gen 32GB Space Grey
And the one in column H are deviate a bit from...
=IF(F3>=90,”A”,IF(F3>=80,”B”,IF(F3>=70,”C”,IF(F3>=60,”D”,”F”))))
Keep getting #NAME? Error
Trying to compute a letter grade score from the number grades listed in column F
Any help, even an alternate formula, would be appreciated
Hi, all!
I'm working on a program that would track iPads used by our employees.
Ideally, the system would allow me to press a button to activate a search VBA, scan a bar code on the iPad and once the scanstring is located (in column A), allow me to scan an employee's ID card to populate the...
Hello,
I was wondering if you anybody came across solutions to transform excel models into user friendly mobile or web interactive dashboard. I know SAS crystal xcelsius may do that, but they have a Flash version that doesn't run on iPad.
Here is an example of web model we have developed...
I'm new to the forum. I'm hoping I can get some advice. I work in a showroom environment. I am barcoding every product in my showroom. I am using a vlookup command and loading information about each product into an excel spreadsheet. Using an ipad, I would like my staff to share this excel...
[Cross-posted from Excel Forum.]
Hi there,
A couple of months ago I reached out to the community and asked whether some spreadsheets would work better as apps. For us, the answer is obvious, as we have helped create apps based on Excel sheets for years, mostly for hospital use. We've seen...
Does anyone have a tip to prevent iPad Numbers from basically totally unlocking ALL security settings on an Excel file. I want to share a locked up file, but if my contractors have an iPad and they download out of my Dropbox onto Numbers, the file security is totally wiped clean.
Ideas?
I'm hoping it's possible to run an xlm Excel file VBA / macro code on Adriod tablet, during a job interview situation, in order to showcase my work. Is this technically feasbile ? I don't want to bring a lap-top, for fear of the hassle the interviewer wants me to modify the code on the spot...
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.