User Profile
SunnyPhoenix1
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Is there a function to multiple same row of two tables? MMULT does not
Is there a function to multiple cell for cell of two Tables? Otherwise, to use MMULT, my understanding is I need to transpose; if so, wouldn't date information across a row of columns become unconventional (vs a column of dates)? I prefer a function similar to MMULT but different EXAMPLE (screenshot below) Table A, as downloaded, has Headers of Rates; Column 1 has 12 rows (Jan-Dec). Table B is my data entry; Headers of Multiple Foreign Currencies; 12 rows (Jan-Dec). Is there a function to multiple Rate to each Foreign Currency without Transposing? To use MMULT, do I not have to transpose, say Table A? Headers would become a Column (a row for each Rate) Dates would become Headers (a column for each Month) IMHO, it is preferable to keep conventional view of Historical Exchange Rates; that is without transpose.With Office 365 Excel Online, Edge iPadoS 17.1.1, how to reference this from other Workbook?
I need help to reference separate Workbook using Office 365 Excel Online on ipadOS 17.1.1. Following steps worked for Windows desktop but not in with Office 365 Excel Online. open two instances of Edge login Office 365 for step 1 Open a workbook A in instance 1 Open a workbook B in instance 2 In cell of Workbook A, type in equal Sign Then click on Workbook B cell
