Builds reconciliation spreadsheet

バージョン 1.0.0.0 (16.3 KB) 作成者: Aman Siddiqi
Combines two spreadsheets with different row headers using two row header matching techniques.
ダウンロード: 960
更新 2007/5/18

ライセンスがありません

You have two spreadsheets you want to join into one. But the names at the front of each row are not identical. So you can't match them. This script allows you to join them using two methods. It truncates the row name, assuming most the differences come after the first few characters. For instance, "Microsoft Corp Loan" & "Microsoft CL" A vLookup won't work. So the script truncates them both to MICROS, and matches them.

Also, there are two spreadhseets that contain name mapping. You can match "welding services" on one sheet to "metal works" on the other. There are two spreadhseets depending which column on the final spreadsheet you want altered. This is also useful for separating 3 distinct entries. For Micrsoft can be mapped MICRO1, MICRO2, MICRO3.

I wrote this for a specific spreadsheet at work. But you can modify the code for yourself instead of starting from scratch. Good luck.

引用

Aman Siddiqi (2024). Builds reconciliation spreadsheet (https://www.mathworks.com/matlabcentral/fileexchange/15026-builds-reconciliation-spreadsheet), MATLAB Central File Exchange. 取得済み .

MATLAB リリースの互換性
作成: R14SP1
すべてのリリースと互換性あり
プラットフォームの互換性
Windows macOS Linux
カテゴリ
Help Center および MATLAB AnswersSpreadsheets についてさらに検索

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
バージョン 公開済み リリース ノート
1.0.0.0